Available since: 1.6.3
searchwp_big_selects
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 functions.php
:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
add_filter( 'searchwp_big_selects', '__return_true' ); |