UBB.Developers Forums UBB.threads 6 V5.php Modifications full text index, faster searches

Apologies for not giving credit... I forgot who posted this, I think we lost it.
Max

hmmmm.. don't think we have mysql 4+ installed here, I'll need to test it on my test server... thank you []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

Sorry if that was unclear... you can still use it on any version that allows full text indexing (current production version does), and use the second section for the change. What you will lose is the ability to use the full index on "AND" searches. "Entire Phrase" doesn't work either way, because indexing is done on a word-by-word basis.

So if you're not using 4.01, this speeds up the "Or / any of the words" search option. On my installation, I modified the default search option to "or" in order to get a larger proportion of accelearted searches.

Regards,
Max

if the search for a phrase is done intelligently, then it would first search for "all" of the words, which is fast, coz it is indexed.

Then it would need to search for the phrase only in these results, where all of the phrase words occur

should be a very big speed advantage, still