Optimizing searches on short_desc

Joel Peshkin bugreport at peshkin.net
Wed Jan 21 14:33:26 UTC 2004



I noticed that most searches for strings in short_desc do not take 
advantage of the fulltext index. 

3 questions:

1) myk - Do you have any data showing what fraction of all BMO searches 
are "contains all words/strings" on the summrary?

2) bbaetz - would this be better using MATCH (short_desc) AGAINST 
('+word +word' IN BOOLEAN MODE) instead of the current index-confounding 
query?

3) should we change it?






More information about the developers mailing list