OpenCart Community

Hello,

I have a problem with time to first byte on ALL pages. I have disabled product/category count but the problem still persist. Any suggestions ? I will appreciate any help.

http://test.profumino.it

oc. 1.5.5.1

Is there a possibility to know which call is causing this delay ??

There's a vQmod script for logging database query times from qphoria. Search the forum and you should find it. I believe it will need some adjustment for 1.5.5.1. You can also try upgrading to the most recent version of vQmod. It has speed improvements, especially over older versions.

I don't know it kind of strange. I upgraded to the last vqmod, but still no improvements. It seems that the first bytes need some time.
I have the same site on 1.5.1.3 with different template and works great.

If you're using webpagetest.org keep in mind that it will fail you on TTFB even when you might have made a big improvement. I've seen upgrading vQmod decrease TTFB by 0.4 seconds which is substantial but the site still failed because TTFB was 2 seconds.

I'd start by testing TTFB on a static page on your server. If the issue persists the problem is the server or network setup. If it goes away you'll need to methodically step through different possible bottlenecks.

As I said I have the same site on the same server : profumino.it , which has a first time to byte like 0,5seconds or so... meanwhile this newer site test.profumino.it has a 4 seconds - and also it feels like a lag when browsing.

Ok I got it ... it's product_to_category database with MORE THAN 65.000 entries. If anyone know any fix for that I would be more than happy to listen.