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..
21 freelancers are bidding on average €182 for this job
Hi, we have check all details with all points and now we are interested with this job so please provide one chance to us related this job please check your PMB for more details Thanks
I think we need more details to start with the project (indexes, the output format [straight html, json, xml...]), so please read PM and we may get it easilly