Note: You are viewing the documentation for Version 3View Version 4 Docs

Documentation

View the installation guide, browse the Knowledge Base, find out about SearchWP's many hooks, get support

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:

searchwp-admin-bar-error

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:

<?php
add_filter( 'searchwp_big_selects', '__return_true' );
view raw gistfile1.php hosted with ❤ by GitHub
Fix keyword search on your site. No coding required!

Now you can utilize all of the content that's gone unrecognized by native WordPress keyword search instantly with SearchWP

Get SearchWP