Title: Large SELECT Query Warning
Last modified: June 10, 2018

---

# Large SELECT Query Warning

 *  Resolved [Tony Hayes](https://wordpress.org/support/users/majick/)
 * (@majick)
 * [8 years ago](https://wordpress.org/support/topic/large-select-query-warning/)
 * I got this error in my logs, not a big deal for me since just testing your plugin
   out at the moment, but thought you should know about it, seems like you may want
   to optimize this MySQL query:
 * [10-Jun-2018 11:03:20 UTC] WordPress database error The SELECT would examine 
   more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 
   or SET MAX_JOIN_SIZE=# if the SELECT is okay for query SELECT l.*
 *  FROM bbq_gamipress_logs AS l
 *  LEFT JOIN bbq_gamipress_logs_meta AS lm0 ON ( l.log_id = lm0.log_id ) LEFT JOIN
   bbq_gamipress_logs_meta AS lm1 ON ( l.log_id = lm1.log_id )
 *  WHERE l.user_id = ’59’
 *  AND ( ( l.type = ‘event_trigger’ ) AND ( l.trigger_type = ‘gamipress_bp_group_publish_activity’)
   AND ( lm0.meta_key = ‘_gamipress_activity_id’ AND lm0.meta_value = ‘398’ ) AND(
   lm1.meta_key = ‘_gamipress_group_id’ AND lm1.meta_value = ’17’ ) )
 *  ORDER BY l.date DESC
 *  LIMIT 1 made by do_action(‘wp_ajax_post_update’), WP_Hook->do_action, WP_Hook-
   >apply_filters, bp_legacy_theme_post_update, groups_post_update, do_action(‘bp_groups_posted_update’),
   WP_Hook->do_action, WP_Hook->apply_filters, gamipress_bp_group_publish_activity,
   do_action(‘gamipress_bp_group_publish_activity’), WP_Hook->do_action, WP_Hook-
   >apply_filters, gamipress_trigger_event, apply_filters(‘gamipress_user_deserves_trigger’),
   WP_Hook->apply_filters, gamipress_bp_trigger_duplicity_check, gamipress_get_user_last_log

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Ruben Garcia](https://wordpress.org/support/users/rubengc/)
 * (@rubengc)
 * [8 years ago](https://wordpress.org/support/topic/large-select-query-warning/#post-10385618)
 * Hi [@majick](https://wordpress.org/support/users/majick/)
 * Thank you so much for your report
 * We are already working on the next GamiPress update that will come with a huge
   number of performance improvements (not just on SQL queries)
 * So for sure, after this update you will stop seeing this type of warnings
 * Best regards
 *  Plugin Author [Ruben Garcia](https://wordpress.org/support/users/rubengc/)
 * (@rubengc)
 * [8 years ago](https://wordpress.org/support/topic/large-select-query-warning/#post-10396403)
 * Hi [@majick](https://wordpress.org/support/users/majick/)
 * We just released a new update for GamiPress (1.5.1) adding a full rework in some
   internal processes making GamiPress much faster than ever!
 * Let me know if this warning has completely dissapeared now
 * Best regards

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Large SELECT Query Warning’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/gamipress-buddypress-integration_66c1e7.
   svg)
 * [GamiPress - BuddyPress integration](https://wordpress.org/plugins/gamipress-buddypress-integration/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/gamipress-buddypress-integration/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/gamipress-buddypress-integration/)
 * [Active Topics](https://wordpress.org/support/plugin/gamipress-buddypress-integration/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/gamipress-buddypress-integration/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/gamipress-buddypress-integration/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Ruben Garcia](https://wordpress.org/support/users/rubengc/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/large-select-query-warning/#post-10396403)
 * Status: resolved