We are an in-process online store, we currently have a complete e-commerce script tailored for us.
Looks like the product catalog script (we currently have more than 20,000 products on this MySQL table) needs to be reviewed and revised due to low speed performance, very likely caused by MySQL. Average page load speed according to Google Analytics is around 8-9 seconds and this can be significantly improved in my opinion.
So here is the task:
1. Review and analyze what parts of the MySQL queries source the slowness
2. Come up with a new product catalog script, selectable with filters etc (preferably with ajax, no page-refreshing + php+mysql caching)
3. Fix it, provide us a new and fast product catalog (NOTE THAT THIS IS A PROJECT ONLY FOR "products.php" OF THE WEBSITE, ONLY CATALOG-WISE)
I am able to provide any database or script regarded question and/or information per your request on private messages.
****DO NOT BID IF YOU ARE NOT A MYSQL EXPERT, IT IS THE KEY POINT****