Releases for Views Fast Search

• 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

stable 5.x release

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