Hey all... I've done some digging into what makes zen cart slow in some instances, and believe mine is my service provider and the SQL server (based off previous threads) however I wanted to have some of you that know more, look at it, and just see if that is for sure what it looks like to you, or if you feel something else is going on.
I've checked about all I can, the site uses about 60products, and the database is only 1.2MB or so... I host a different site using Invision power board on a different domain, with a 40-50MB database (which appears to be on the same SQL Server, but different apache server) which is fast.
http://www.ofagear.com
Please check it, and look to see if something sends up a red flag to you aside from it being an SQL server configuration issue... also if there are specific things I can tell them I've been told to have checked in the SQL config, please let me know... they have already suggested they may have to move the site to a different server... when I first installed the site seemed pretty quick, but has definitely slowed down, including the admin section, which leads me to believe it's the SQL as I only did appearance mods to the site, and didn't touch any admin files
I have tried turning images off, utilizing the gzip, going back to the default template (in case I messed something up), etc just to check, the most speed improvement I seem to be able to make is around 1 second, but with load times near 30seconds total, 1 second is nothing.
I'm working with the hosting provider regarding the problem (Dreamhost) they say they have similar reports, but have not been able to nail down the problem, even though I told them I've heard its an SQL server configuration issue, and it's obvious its a database problem due to the "query time" at the bottom of the page, they wanted to make sure it was entirely a database driven site that had the problem, or static pages etc... even though I tried to tell them initially where the problem was... hopefully I made it clear this last time I know it must be the database, since the parse time is only on average .5-1seconds longer than the query time.
Thanks.
Bookmarks