Closed

MySQL DB/queries optimization

This project was awarded to websterz for €70 EUR.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
€30 - €250 EUR
Total Bids
23
Project Description

A website running a big database needs some MySQL/PHP optimization to reduce server load and get rid of slow queries.

The main problem comes with result pagination. Homepage loads fine but when going to page nr 16,000 of results, and ordering results by name, by date, by name and date, etc, site is slow and takes a lot of CPU.

This specially happens when Googlebot is crawling the site for indexing.

Database size is 2GB. Attached are some actual PHP files with the queries used, the database structure (.sql) with indexes etc, and a screenshot of phpMyAdmin where you can view number of rows, size of each table etc..

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