Fast Search

by dragonexpert 7 Stars 783 Downloads

increases search speed

Project Details

This plugin increases the speed of searches on your forum by creating more server friendly queries.  Please note that thread read status will not be tracked because it adds significant overhead.  The same is true of the dot icons.  I highly recommend MySQL >= 5.6 so you can use FULLTEXT index on Innodb storage engine.  Small forums will not see much performance gain, but forums with large amounts of posts should.

If your forum has many threads, you may wish to manually add the field "moved" to the mybb_threads table in PHPMyAdmin.  You should also create an index that is on both the visible and moved columns.  This is not created on installation on purpose because large forums it could take significant time to execute from building the index.  It is best if you shut down the forum while waiting for the index to be built.

While this was built for the 1.8 series, it should still work on the 1.6 series.  If you experience any problems using it for the 1.6 series, please post in the release thread.

Please share your thread total, posts total, user total, and if it seems any faster with me via PM.  I like being able to see data.
Author
dragonexpert
Collaborators
None
Version
3.0
Submitted
2014-08-31, 01:23 PM
Last Updated
2015-04-09, 03:06 PM
Bug Tracking
External
MyBB Versions
1.8.x