Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 SQL Full-text search, where am I doing wrong?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

SiSL
Average Member

Turkey
671 Posts

Posted - 27 October 2005 :  20:34:23  Show Profile  Visit SiSL's Homepage
I have installed this mod (at http://forum.snitz.com/forum/topic.asp?TOPIC_ID=54214)

In my MS SQL, I have set Indexes, included Message and Subject and Replies to catalog for FORUM_REPLY, FORUM_TOPICS, A_REPLY, A_TOPICS..

Made a Full Population and changed tracking to Index at background and changed schedule to Incremental Population every 2 hours or so, it completed full population and started incremental population like 2-3 days, while was doing big stuff, CPU was topping but now, everything is normal, scheduled and going..

Uploaded scripts and changed variable in there to use FT.

Problem is, I get no results always 0. Database is large (like 300K replies, 15-20K topics) and words I use for test is words that are not in "noise words" in script.

What am I doing wrong?



CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod

Edited by - SiSL on 27 October 2005 20:36:31
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07