Patch for increased performance under MySQL
Chris Bray - September 21, 2008 - 22:50
| Project: | Fuzzy Search |
| Version: | 5.x-1.2 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs review |
Jump to:
Description
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 |
#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.