Posted by Chris Bray on September 21, 2008 at 10:50pm
Jump to:
| Project: | Fuzzy Search |
| Version: | 5.x-1.2 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Here's a patch adding a couple of indexes that significantly increases search performance when running on MySQL.
In my case this patch dropped the query time for a search from 6 seconds to under 100ms (circa 20000 nodes, 500000 ngrams).
It's just adding a couple of indexes... What do you think?
| Attachment | Size |
|---|---|
| fuzzysearch.install.patch | 517 bytes |
Comments
#1
Nice idea, but in my fuzzysearch (5.x-1.2) i don't have ngram, but trigram, so i added the indexes as follows:
CREATE INDEX ix_search_fuzzy_index_ngram ON search_fuzzy_index (trigram);CREATE INDEX ix_search_fuzzy_index_completeness ON search_fuzzy_index (completeness);
I hope it will now increase search performance.
#2
I recently took over this module. I'm going through all the old issues and closing them if possible. I'm not making any changes other than security fixes to the Drupal 5 version.
If you would still like to see this in the Drupal 6 version, please create a new issue or reopen this one, changing the version number.
Thanks,
awolfey