oscomerce mysql query optimization

I'm in the middle of putting this site together [url removed, login to view]

I have imported 10,000 products into it and the more products there are the slower it gets. If I disable the STS module (simple template system) then the speed is fine. So I believe the sped issue is within STS. I need someone to debug this and fix the speed issue.

After completion I need the name of the files you altered so I can apply the fix to several other sites we are working on.

I have the database on another server because I was trying multiple servers out to see if the problem wasn't wit the server. It turns out its not with the server but with the code. During the day when servers are busier this thing can slow to a crawl so I need to get the query time fixed.


Færdigheder: Indkøbsvogne

Se mere: n query, fine products, wit, speed optimization, simple query, Query optimization, mysql query, fix mysql query, database optimization, crawl a we, together mysql, simple debug, fix query, mysql completion, optimization database, putting products, crawl sites, fix code debug, simple mysql database template, query query, mysql query slow, imported products, mysql slow, sped, oscommerce disable

Om arbejdsgiveren:
( 406 bedømmelser ) Las Vegas, United States

Projekt-ID: #296138

2 freelancers are bidding on average $140 for this job


show me the details thanks.

$80 USD på 1 dag
(102 bedømmelser)

let me do this project, im very good at area.

$200 USD in 2 dage
(3 bedømmelser)