Releases for Views Fast Search

Per the conversation on the devel thread, I'm creating new latest releases of several modules. This one has been stable for quite a long time...

• 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:

1. 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)
2. ALTER TABLE search_index ADD INDEX (fromsid, word); (now part of the update .install process).
3. ALTER IGNORE TABLE search_index ADD UNIQUE INDEX (sid, word, type, fromsid); (see #143160, now part of the update .install process).
4. admin/settings/search – select UNIQUE
5. admin/settings/search – set the number of comments node rank to 0 (without which the performance results are not reproducable)
6. 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.

• 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:

1. 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)
2. ALTER TABLE search_index ADD INDEX (fromsid, word); (now part of the update .install process).
3. ALTER IGNORE TABLE search_index ADD UNIQUE INDEX (sid, word, type, fromsid); (see #143160, now part of the update .install process).
4. admin/settings/search – select UNIQUE
5. admin/settings/search – set the number of comments node rank to 0 (without which the performance results are not reproducable)
6. 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.

stable 5.x release

stable 5.x release

Stable 4.7 version

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:

1. 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)
2. ALTER TABLE search_index ADD INDEX (fromsid, word); (now part of the update .install process).
3. ALTER IGNORE TABLE search_index ADD UNIQUE INDEX (sid, word, type, fromsid); (see #143160, now part of the update .install process).
4. admin/settings/search – select UNIQUE
5. admin/settings/search – set the number of comments node rank to 0 (without which the performance results are not reproducable)
6. 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.

4.7 development version