Title: Comment Query
Last modified: August 19, 2016

---

# Comment Query

 *  [gearpatrol](https://wordpress.org/support/users/gearpatrol/)
 * (@gearpatrol)
 * [16 years ago](https://wordpress.org/support/topic/comment-query/)
 * Hi,
 * If anyone could aid with this problem we’d greatly appreciate it. Our site ([http://gearpatrol.com](http://gearpatrol.com))
   just implemented a new custom theme and it appears that we are pegging our MySQL
   server at over 80% utilization during most of the day, and at time 100%.
 * Evidently, it’s due to a plugin or code that’s generating the following query:
 *     ```
       SELECT * FROM wp_comments WHERE  ( comment_approved = '0' OR
       comment_approved = '1' ) ORDER BY comment_date_gmt DESC
       ```
   
 * The problem being that there is no limit clause to limit the amount
    of data 
   it returns and the WHERE is too generic as the query is returning about 95% of
   our comment table.
 * Does anyone know if any of the following plugins might be causing this or can
   help us resolve? We would greatly appreciate it and would be glad to send over
   a piece of gear (we review lots of gadgets and gear) for your help. Thank you,
   in advance!
 * **Plugins:**
 * After The Deadline
    Akismet All in One SEO Pack Amazon Auto Link Cimy User Extra
   Fiields Custom Field Template Feedburner FeedSmith Google XML Sitemaps Login 
   Lockdown My Category Order NextGen Gallery Outbrain PollDaddy Post Template ShareThis
   TweetMeme Retweet Button Ultimate Google Analytics Wordpress.com Stats Wp-Email
   Wp-Memory-Usage Wp-Optimize Wp-Postratings Wp-JS WP-Security Scan Wp-Super Cache

Viewing 1 replies (of 1 total)

 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [16 years ago](https://wordpress.org/support/topic/comment-query/#post-1491550)
 * Have you tried:
 * – deactivating **all** plugins to see if this resolves the problem? If this works,
   re-activate the plugins one by one until you find the problematic plugin(s).
 * – switching to the default theme to rule out any theme-specific problems?

Viewing 1 replies (of 1 total)

The topic ‘Comment Query’ is closed to new replies.

## Tags

 * [Plugin Problems](https://wordpress.org/support/topic-tag/plugin-problems/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [esmi](https://wordpress.org/support/users/esmi/)
 * Last activity: [16 years ago](https://wordpress.org/support/topic/comment-query/#post-1491550)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics