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 * ************************************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
