views_fastsearch 5.x-1.x-dev
| Download | Size | md5 hash |
|---|---|---|
| views_fastsearch-5.x-1.x-dev.tar.gz | 15.13 KB | f1e15b0b357a83ca7341b764a2d51d4b |
Nightly development snapshot from CVS branch: DRUPAL-5
Last updated: August 21, 2008 - 00:13
The new improved views fastsearch development is mostly done. It’s time for testing and fixing!
- significantly faster than the previous fastsearch
- solves the multi-term join problem (5-6 term searches on large sites experienced slowness; plus mysql limits joins to 21 tables)
- fixes for OR and EXCLUDE terms
- added score field
- better score sorting, not perfect yet
- added search results view
To use the 5.x-dev branch, you must:
- ALTER TABLE search_index ENGINE=MyISAM; (you must do this yourself, but a warning is shown on admin/settings/search if this is not done)
- ALTER TABLE search_index ADD INDEX (fromsid, word); (now part of the update .install process).
- ALTER IGNORE TABLE search_index ADD UNIQUE INDEX (sid, word, type, fromsid); (see #143160, now part of the update .install process).
- admin/settings/search – select UNIQUE
- admin/settings/search – set the number of comments node rank to 0 (without which the performance results are not reproducable)
- apply the views subqueries patch - #143888
Thanks to Moshe for his ideas on the search HAVING clause (which is very similar to how core search does it) and for discovering ALTER IGNORE TABLE. And credit to Robert for pointing out that search_index had a dup problem in the first place.