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.