views_fastsearch 5.x-1.x-dev
Nightly development snapshot from CVS branch: DRUPAL-5
First released: December 8, 2006 - 04:03
First released: December 8, 2006 - 04:03
Download: views_fastsearch-5.x-1.x-dev.tar.gz
Size: 15.13 KB
md5_file hash: f1e15b0b357a83ca7341b764a2d51d4b
Last updated: August 21, 2008 - 00:13
View usage statistics for this releaseSize: 15.13 KB
md5_file hash: f1e15b0b357a83ca7341b764a2d51d4b
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.