WP site with too many queries needs optimization (PHP and MySQL)

This project received 9 bids from talented freelancers with an average bid price of $197 USD.

Get free quotes for a project like this
Employer working
Project Budget
Total Bids
Project Description

Our BuddyPress/Wordpress site [url removed, login to view] is using a lot of queries. Not unusual when it comes to WP but this is extreme. Our main coder can't figure it out cause he's not used to optimizing code. We need someone who's a master with PHP and MySQL, currently our VPS crashes one or twice per week when there's a lot of traffic.


# Time: 130207 18:27:40
# User@Host: site_hil[site_hil] @ localhost []
# Query_time: [url removed, login to view] Lock_time: [url removed, login to view] Rows_sent: 150 Rows_examined: 5957974
SET timestamp=1360250860;

As you can see our queries are taking more than 1 second to execute (on regular load) and are examining almost 6M rows.

Check the site, look at our DB, check our custom PHP code and see if you find anything. You'll get access to WP, FTP and cPanel. WHM access also available. Comment and log everything you edit. Using only a WP cache plugin isn't a solution to bring down queries, we need a smarter solution!

Milestone #1 released once you've made an attempt and sent us a list of edits you've made.
Milestone #2 will be released after 72 hours when the site have had time to test and see if your fixes have reduced server load. We always pay on time, check our reviews!

We don't have a huge budget (the site is our hobby ;) but we'll give you a great review and loads of other work will be available! If you send us a PM, include a "I've read the description" so we know you've actually have. Thanks!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online