views_fastsearch 5.x-2.x-dev
Nightly development snapshot from CVS branch: DRUPAL-5--2
Download: views_fastsearch-5.x-2.x-dev.tar.gz
Size: 12.98 KB
md5_file hash: e2aa943b721bb0bdfc5b86233a92b392
First released: August 11, 2007 - 04:33
Last updated: August 11, 2007 - 12:10
Download: views_fastsearch-5.x-2.x-dev.tar.gz
Size: 12.98 KB
md5_file hash: e2aa943b721bb0bdfc5b86233a92b392
First released: August 11, 2007 - 04:33
Last updated: August 11, 2007 - 12:10
- 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 take advantage of the new searching, you should:
- 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.