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?

CommentFileSizeAuthor
fuzzysearch.install.patch517 bytesChris Bray

Comments

kardave’s picture

kardave commented

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.

awolfey’s picture

awolfey commented
Status: Needs review » Closed (fixed)

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