Available since: 1.6.3
MySQL (the database engine that powers WordPress sites) comes with many configurable options. One of those options is an upper limit to the number of SELECT statements that can be performed in a single query. This limit is in place for performance considerations. Depending on your (or your host’s) MySQL configuration, you may have seen this Admin Bar warning when first trying SearchWP:
Don’t worry, we can easily get around this issue using this hook.
Example: To prevent MySQL from killing queries due to a SQL_BIG_SELECT limitation, add the following to your active theme’s
|add_filter( 'searchwp_big_selects', '__return_true' );|