Zen Cart MySQL Database Indexing and Search Query Optimization

Zen Cart MySQL Database Indexing and Search Query Optimization

Cancelled

Job Description

I need a MySQL Guru to look at my slow query log and determine which tables need indexing and also to look at my search queries and optimize them. I am currently dealing with the following stats:

Parse Time: 10.743 - Number of Queries: 86 - Query Time: 10.5452899012

I am using:
Zen Cart 1.38a
PHP - 5.2.16
MySQL - 5.0.96
Linux Dedicated Server

My database is getting large, 50k+ Products, 15k+ customers.

---
Skills: linux