Post by madfish » Sat Aug 03, 2013 8:40 pm

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

My fragrance parfum site profumi


New member

Posts

Joined
Thu Dec 03, 2009 8:49 pm


Post by madfish » Sun Aug 04, 2013 2:58 am

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

My fragrance parfum site profumi


New member

Posts

Joined
Thu Dec 03, 2009 8:49 pm


Post by rph » Sun Aug 04, 2013 6:13 am

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.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by madfish » Sun Aug 04, 2013 6:37 am

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.

My fragrance parfum site profumi


New member

Posts

Joined
Thu Dec 03, 2009 8:49 pm


Post by rph » Sun Aug 04, 2013 11:30 am

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.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by madfish » Sun Aug 04, 2013 6:11 pm

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.

My fragrance parfum site profumi


New member

Posts

Joined
Thu Dec 03, 2009 8:49 pm


Post by madfish » Sun Aug 04, 2013 8:02 pm

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.

My fragrance parfum site profumi


New member

Posts

Joined
Thu Dec 03, 2009 8:49 pm

Who is online

Users browsing this forum: Google [Bot], hxkurt and 180 guests