MySQL Performance Test & A Fast PHP Product Catalog Script w/ AJAX

IN PROGRESS
Bids
12
Avg Bid (USD)
N/A
Project Budget (USD)
$10 - $100

Project Description:
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****

Skills required:
AJAX, jQuery / Prototype, MySQL, PHP
Hire buckybadger
Project posted by:
buckybadger Norway
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire powertech
$ 163
in 3 days
$ 74
in 1 days
$ 200
in 3 days
$ 111
in 3 days
$ 101
in 2 days
$ 105
in 3 days
Hire hckrsatwork
$ 55
in 5 days
$ 100
in 3 days
$ 55
in 3 days
Hire kuryaki
$ 77
in 3 days