fulltext not for me/alternatives
| From: | Ben Edwards | Date: | Sun, 21 Oct 2001 10:02:03 +0000 |
| Subject: | fulltext not for me/alternatives | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13569@lists.php.net to get a copy of this message | ||
I have a bit of a problem with using freetext indexes because there are a LOT of important 3 letter words in my database and as I am using shared hosting so do not have the option to recompile MySql. Can't quite figure why 3 is not the default (car, dog, cat war, man, bed, ....). Maybe so you would have to recompile to be able to find s_e_x ;).
The other thing I cant figure out is how much data you need for it to actually work well. There is a reference in the manual saying it works better on bigger data sets but no indication as to what it means by big.
Anyway, this means I am looking for an alternative which can be implemented on php4. Has anyone any suggestions?
Ben
3.23.41-log
Also in the manual it mentions freetext search
**************************************************************
* Ben Edwards +352 091 429995 * * Homepage http://www.gifford.co.uk/~bedwards * * i-Contact Progressive Video http://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol's radical news http://www.bristle.co.uk ** PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * **************************************************************