Title: Large SQL statements kill our server
Last modified: August 30, 2016

---

# Large SQL statements kill our server

 *  Resolved [Dorian K](https://wordpress.org/support/users/dorian-k/)
 * (@dorian-k)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/large-sql-statements-kill-our-server/)
 * Hello,
 * we bought the auction tool, and urgently need support, since it just totally 
   killed our server when the auctions reached there ending time. And we only had
   about 20 items and probably only about 15 people placing bids. Every 5 minutes
   one auction is ending.
    We use the proxy bid.
 * Very obvious that this is because of very bad performing SQL statements.
 * All support contact channels seem not to work. How to really reach your “world
   class support”?!
 * We have the same problems like in this posts:
    [https://wordpress.org/support/topic/bidders-who-want-to-increase-their-proxy-bid-end-up-bidding-against-themselves?replies=1](https://wordpress.org/support/topic/bidders-who-want-to-increase-their-proxy-bid-end-up-bidding-against-themselves?replies=1)
   [https://wordpress.org/support/topic/online-auction-disaster-bidders-cant-access-website-5-hrs-before-auction-ends?replies=3](https://wordpress.org/support/topic/online-auction-disaster-bidders-cant-access-website-5-hrs-before-auction-ends?replies=3)
 * This is one of the SQL statement that kill the server:
 * SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
   ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id
   IN (3)
    ) AND wp_posts.post_type = ‘ultimate-auction’ AND ((wp_posts.post_status
   = ‘publish’)) AND ID IN( SELECT post_id FROM wp_postmeta WHERE meta_key = ‘auction_bought_status’
   AND meta_value = ‘bought’ UNION ALL SELECT s3.post_id FROM wp_wdm_bidders s1,
   wp_postmeta s3 WHERE s3.post_id = s1.auction_id AND s3.meta_value <= s1.bid AND
   s3.meta_key = ‘wdm_lowest_bid’ AND s1.bid=(SELECT MAX(s2.bid) FROM wp_wdm_bidders
   s2 WHERE s1.auction_id = s2.auction_id) UNION ALL SELECT s3.post_id FROM wp_postmeta
   s3 WHERE s3.meta_key = ‘wdm_auction_expired_by’ AND s3.meta_value = ‘ua_best_offers’)
   GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC;

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

 *  [Word Press Auction](https://wordpress.org/support/users/oahuauctions1/)
 * (@oahuauctions1)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/large-sql-statements-kill-our-server/#post-6835864)
 * Same problem here. We switched from GoDaddy shared server to Lionde server and
   the plug in still stopped working mid-way through the auction. The Linode tech
   said it was a problem with SQL.
 *  Plugin Author [Nitesh](https://wordpress.org/support/users/nitesh_singh/)
 * (@nitesh_singh)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/large-sql-statements-kill-our-server/#post-6835965)
 * Hi,
 * Dorian has shared a few findings today via PRO support. I’ll research more on
   it and will followup via support ticket.
 * If anyone is having any other problem regarding PRO, please open support tickets
   for further investigation.
 * Regards,

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

The topic ‘Large SQL statements kill our server’ is closed to new replies.

 * ![](https://ps.w.org/ultimate-auction/assets/icon-128x128.png?rev=1494738)
 * [Ultimate Wordpress Auction Plugin](https://wordpress.org/plugins/ultimate-auction/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ultimate-auction/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ultimate-auction/)
 * [Active Topics](https://wordpress.org/support/plugin/ultimate-auction/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ultimate-auction/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ultimate-auction/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [Nitesh](https://wordpress.org/support/users/nitesh_singh/)
 * Last activity: [10 years, 5 months ago](https://wordpress.org/support/topic/large-sql-statements-kill-our-server/#post-6835965)
 * Status: resolved