Current time: 12-08-2019, 03:50 AM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
15.074 second TTFB. Needs Help!
11-01-2012, 06:07 AM
Post: #1
15.074 second TTFB. Needs Help!
Hi all, I from Brazil.


Why my site have so long TTFB (between 8 and 19 seconds)? any help?

Hosting: IWeb
Mysql + PHP + Apache


http://www.webpagetest.org/result/121031_VT_GP2/
Find all posts by this user
Quote this message in a reply
11-02-2012, 12:25 AM
Post: #2
RE: 15.074 second TTFB. Needs Help!
Are you running on shared hosting or something dedicated where you have access to install something like New Relic?

9 times out of 10 is is because of slow MySql queries (combined with a lot of queries) but you need to instrument the actual application to figure out where the time is going (something like New Relic can do that for you quite quickly).
Visit this user's website Find all posts by this user
Quote this message in a reply
11-02-2012, 02:46 AM
Post: #3
RE: 15.074 second TTFB. Needs Help!
Patrick,

I have a Windows dedicated server. Researched at New Relic, but I think there's no way to install it on windows with PHP.

I did the following test: I delete all the source code of my Home page and leave only written "test". The result was that the first byte still remained between 8 and 19 seconds.

I use Zend Server to run PHP.
Find all posts by this user
Quote this message in a reply
11-02-2012, 03:25 AM
Post: #4
RE: 15.074 second TTFB. Needs Help!
Out of curiosity, any particular reason you are using Windows to host php? The two don't necessarily get along all that well for production sites.

If you serve a static html page does it still have the 8 second time or is it fast then? That will let you know if it is a configuration issue with teh web server itself or with how the server interacts with php (spinning up a new cgi instance for each request for example).
Visit this user's website Find all posts by this user
Quote this message in a reply
11-02-2012, 04:54 AM
Post: #5
RE: 15.074 second TTFB. Needs Help!
I imagined you would ask that. I chose Windows because I dont know anything about Linux, I did't want to be depending of others, and paying to use the server.

Look that:

Static, its not all the time which this time, but..
homologa.resolucaodequestoes.com.br/
http://www.webpagetest.org/result/121101_FD_ESE/

Dinamic:
http://www.resolucaodequestoes.com.br
http://www.webpagetest.org/result/121101_T2_EXX/


I can't divulge the website until we resolve this slowness.

Sorry for my english.
Find all posts by this user
Quote this message in a reply
11-02-2012, 09:50 AM
Post: #6
RE: 15.074 second TTFB. Needs Help!
I found an error in a select at Home. Got lower the First byte significantly, but still is not 100%. I will tray other things.
Find all posts by this user
Quote this message in a reply
11-02-2012, 11:39 PM
Post: #7
RE: 15.074 second TTFB. Needs Help!
http://www.webpagetest.org/result/121102_T1_AQX/
21.634s

OMG
Find all posts by this user
Quote this message in a reply
11-04-2012, 12:22 AM
Post: #8
RE: 15.074 second TTFB. Needs Help!
I would say you have a very serious configuration problem with your backend, and the most likely culprit is your mysql database. You should enable the slow-query-log of your mysql server to check out which queries aren't optimized, and start adding indexes to it!
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)