[drupal-devel] slow queries?

Steven Wittens steven at acko.net
Sat Jun 25 17:48:22 UTC 2005


> steven probably understands this better than anyone? can anything be 
> done here, steven?

The only problem I know of is leading wildcards in search terms. These 
prevent the index on the word column from being used, hence a full table 
scan is done. This problem has gotten worse since the "try leading 
wildcards automatically if nothing was found" patch.

I have some architectural changes for search.module in my head which 
might help with this (though the main point is to introduce phrase 
searching), but I won't have time for this until my exams end.

Steven Wittens




More information about the drupal-devel mailing list