Downloads
Download tar.gz
16.16 KB
MD5: 7b74c15a774c541b47519ddceba172e2
SHA-1: 191393d94de1c7d1dfe354d0c089f534ee3714d2
SHA-256: c00ec3c2b8f53dc3ebd924ae3e84e059926cfc628a387bd096712bbccbfd119f
Download zip
19.08 KB
MD5: f37e34715578c7dbdaf2b55f3829fcac
SHA-1: 371fad341cfde3c3c887d0f35908df9230152073
SHA-256: 10bdafccc5f832c17850c1ea64f4f33efdb8f6743c274e2d6fe5763a791a2b13
Release notes
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.
