MySQL DB/queries optimization
This project was awarded to websterz for €70 EUR.Get free quotes for a project like this
Project Budget€30 - €250 EUR
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..
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online