Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query

According to WP_Query hit max joins… How else can I build a search function that uses custom fields? you should use

$wpdb->query('SET OPTION SQL_BIG_SELECTS = 1');

which makes sense as you set it for the current connection. You create a separate connection through new mysqli and WordPress has another on $wpdb.

Related Posts:

  1. get_results using wpdb
  2. Count & Display Database Queries
  3. Export wordpress table to excel
  4. How best to inject ads between posts in the loop?
  5. Change SQL get_results to search for posts with custom term in custom taxonomy
  6. Change all http to https in mysql databse?
  7. WooCommerce – Query for ordered products
  8. PHP variable in WordPress database query
  9. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  10. Query WordPress database by registered date and role
  11. How to prevent WordPress from retrieving data for the last 10 posts in the database?
  12. Query from a different database than the default
  13. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  14. Select Multiple meta_value from WP DB; Single Query
  15. CRUD operations using WordPress database API
  16. Hook directly into query execution
  17. Advanced SELECT query with condtional statements
  18. Select two sums with single get_var statement
  19. Replace/Mute/Stop Search Query
  20. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  21. cache specific data?
  22. How Can I Put Meta_Compare in the Database-Query?
  23. How to paginate information obtained from a query to a custom table?
  24. Historic WordPress database connection
  25. Check if an option exists and get its value in one hit
  26. Query multiple tables at once?
  27. $wpdb->query can’t insert data
  28. Custom WordPress Table wpdb
  29. Best practice to limit results in get_row()?
  30. How to display content from external db with relevant urls
  31. Connecting to a different database
  32. SQL query to set posts in bulk based on the post content
  33. Query Column of Specific ID from Database Table
  34. Custom search query by category id
  35. How to display data from db in select list [closed]
  36. How can I query the db to access current post information?
  37. Compare User meta_value with Product meta_value
  38. How to insert a value to decimal type field using wpdb->prepare?
  39. Join Query on WP_USERMETA Table
  40. Insert NULL value using prepare()
  41. Job and Employee Performance Tracking with Product Safety
  42. WordPress Database Query works in phpMyAdmin but not in the code
  43. wpdb query to insert images in to post/page gallery
  44. Performance bug – slow DB query
  45. How to optimise this database query?
  46. How can we speed up wp_get_nav_menu_items()?
  47. Extracted CSV as Array for Custom Query Loop
  48. Should I Use only wpdb Class to Write Custom Queries?
  49. Generating an HTML table from an array based on dynamic key values
  50. Pulling values from a sepcific row in table
  51. Using class id from array for query
  52. database search feature
  53. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  54. SQL query to rewrite all media URLs to end with .webp
  55. How do I find users by password?
  56. Is it fine to have foreign key as primary key?
  57. Detecting errors generated by $wpdb->get_results()
  58. Restoring WordPress posts from database only
  59. Performance Gains of Relational DB Setup
  60. store simple data in get_option()
  61. What are conventions about the schema of the $table_prefix
  62. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  63. storing database in version control
  64. Is deleting orphaned wp_options entries safe?
  65. How to build a movie database with wordpress?
  66. Sub-domain or 2nd, temporary different domain?
  67. How do i get user data from a custom table in the wordpress database by user ID?
  68. Converting WordPress into Android or iPhone app
  69. Database slowdown after update to 3.4.1
  70. WooCommerce sku location in DB
  71. How to insert data into MySQL database from the form created in WordPress site
  72. Emoji support and MariaDB 10.0.30-
  73. Can I have multiple database users within WordPress?
  74. Modify Database in Multi-Site wp_usermeta table
  75. Form Data not getting stored in WordPress database
  76. $wpdb doesn’t like to store arrays
  77. Connect to a remote database for wordpress in my own hosting server
  78. WordPress ‘repairing database’ in a constant error loop?
  79. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  80. Importing CSV into database table not working?
  81. Problems with moving my WordPress site to another domain/server
  82. Is it important to have integers inserted using %d rather than %s?
  83. Export a custom Mysql database product catalog to WordPress
  84. Connect to database in the header of my WordPress website
  85. WordPress url transformation script
  86. Just created a WordPress Table can’t get $wpdb get row to work – need help
  87. $wpdb->insert not inserting all rows
  88. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  89. How would I see which wordpress posts have a revision history without opening each one?
  90. Creating a custom form with ability to query and submit to SQL
  91. Intermittent Yet Problematic Error – “Error Establishing A Database Connection”
  92. Error: SHOW FULL COLUMNS FROM `pt_participant`
  93. Correct and secure way to access a custom SQL database in a custom PHP template file
  94. Missing latest posts and options after DB migration via phpMyAdmin
  95. Local host to server import problem
  96. Getting deleted users in database
  97. Options of accessing wordpress data from mobile app
  98. Getting data from a table using a query
  99. Database interaction (private-public) [closed]
  100. Weird WP -Cli Error Connection Refused