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.


Kemahiran: Troli Membeli-belah

Lihat lagi: 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

Tentang Majikan:
( 406 ulasan ) Las Vegas, United States

ID Projek: #296138

2 pekerja bebas membida secara purata $140 untuk pekerjaan ini


show me the details thanks.

$80 USD dalam sehari
(102 Ulasan)

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

$200 USD dalam 2 hari
(3 Ulasan)