Slow store - sometimes(!)

My new install runs quite slow at times, and I'm suspecting something at the ISP is causing it... like PHP or SQL server overload. Now at 8pm I can change pages in the store real fast, like 2-3 seconds... this afternoon it was taking 20-30+. I experienced a problem yesterday afternoon too.

GZIP is ON, no SSL (yet), and SQL_CACHE_METHOD is set to 'none'. Have I missed anything?

In an older version I seem to remember a message in the footer that shows load time ... is there a place I can turn that ON for now? Is there a way I can analyze more deeply what's going on (PHP vs SQL response)?

Thanks!

is there a place I can turn that ON for now?
admin > config > logging > display parse times
Now at 8pm I can change pages in the store real fast, like 2-3 seconds.
I have a store with 100,000 items and page parse time are sub-second for most all pages

Shoppers are not patient about this and will go elsewhere

Thanks! At the moment I'm seeing <1 sec parse time most of the time, <2 all the time. I'll see what it does tomorrow afternoon.

Are you on a zen certified host? I was on a non-certified host and had the same issues as you are having. I moved my site to a zen certified host, subsecond pages are the norm, customers are happy! It could well be your ISP.

Oh, ok, it's doing it again already (now 8:50pm):

Parse Time: 25.991 - Number of Queries: 78 - Query Time: 25.200709677689

Does this mean the SQL back-end took 25.200 seconds and the other .791 seconds was PHP interpretation?

Brian1234:

Parse Time: 25.991 - Number of Queries: 78 - Query Time: 25.200709677689

Does this mean the SQL back-end took 25.200 seconds ...?That is correct.