Thread: Site Problems??
View Single Post
Old 09-25-2007   #3
asshanson
immune from paybans
 
asshanson's Avatar
 

Join Date: Oct 2005
Location: West Des Moines
Drives: poorly
Posts: 4,358
Send a message via AIM to asshanson
Re: Site Problems??

Quote:
Originally Posted by scheides View Post
Good idea! I lowered it to 3. I can do 2 as well, if someone can think of a good reason why?
Isn't that a change in the MySQL database settings for full-text searches? Does that require you to rebuild the indexes or is it automatic?

If you lower it to 2 the index will get a lot larger, probably not necessary.


Edit: After one search it's very apparent, this is only going to take effect on new posts unless you manually tell it to rebuild the search indexes.

Also, please automatically include a star after each search word. Otherwise I have to remember to type in turbo* oxygen* in my searches if I wanted to find posts with turbos and some word form of oxygen. It looks like it's already splitting up the search by words so it shouldn't be too hard to add them: ... AGAINST ('+$word1* +$word2* ...' IN BOOLEAN MODE) ...

Last edited by asshanson; 09-25-2007 at 03:50 PM..
asshanson is offline   Reply With Quote