Quote Originally Posted by RodG View Post
Along the same lines, I see you also have both FEC and Cowoa listed among your add-ons. I think these were integrated into a single module way back in 2009?
FEC is installed, but isn't actually used -- just COWOA. Stuck around on the upgrade from 1.5.1 to 1.5.4, I guess.

Quote Originally Posted by RodG View Post

Wow, that's quite a busy site you have there.

This, and the fact that you stated 'it seems to have been slowly running down and down' (as opposed to something that happened overnight) is suggesting *to me* that you could simply be overloading the server. (Either the webserver, but more likely, the SQL server).

Activating the "page parse time" could be useful here.

Shared server or VPS?
How much RAM?
Yeah, we're now averaging 30-40 orders a day through the site.

We kept overreaching our resource limit (80% of our alloted resources on the shared server were going to IMAP accounts in the office), so we literally just upgraded to a VPS (1gb RAM, looks like) this last week and honestly the admin seems to be running more painfully slow than ever (no change on the front end speed, fortunately and unfortunately). I'll activate parse times (i think my front end template removed the placeholder for it, so I'll have to add it back in), and see if I can locate a slow query log activation on the server. If I'm overloading the SQL server, do you have suggestions on how to track that, and possibly fix it?

I might have to bring an outside consultant into look at our stuff directly and see where things are getting overloaded. I'm all self-taught in web development, so I'm sure there are things I'm missing that would seem obvious to a learned or veteran developer. I'm also getting increasingly paranoid that we're outgrowing zencart, but I picked this software because it's easy to customize and seemed scalable.