Current time: 12-17-2017, 12:20 PM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Please help me improving First Byte Time
11-21-2011, 05:17 PM
Post: #1
Please help me improving First Byte Time
http://www.webpagetest.org/result/111121_02_289QT/
http://www.webpagetest.org/result/111121_AQ_289QX/

I run vBSEO, see this thread: http://www.vbseo.com/f2/first-byte-slowe...ime-52021/

Now when I turn off vbseo the time improves to A/B.

I've had my web host working with me for about a month to try to fix slow queries but no help.

Could you guys please advise me what else I can do to improve this?

My website link: http://www.47r-squad.com

I also run cPanel Varnish, EdgeCast CDN, xcache.
Find all posts by this user
Quote this message in a reply
11-26-2011, 08:14 AM
Post: #2
RE: Please help me improving First Byte Time
Also can I have my CDN added to known list?
cdn.47r-squad.com
edge.47r-squad.com
Find all posts by this user
Quote this message in a reply
11-27-2011, 02:13 AM
Post: #3
RE: Please help me improving First Byte Time
Your CDN servers should be correctly identified since they are on MaxCDN/NetDNA. Looking at the test results it looks like all of your content is served from http://www.47r-squad.com though which is why you are failing the CDN check: http://www.webpagetest.org/result/111121...use_of_cdn

Out of the technologies you list, only xcache could possibly help your first byte times for the base page (dynamic content).

There are a couple of posts about optimizing for vBulletin (I believe Marvin has done a lot of work on it) but it essentially comes down to turning off everything that isn't critical for your site in the options. Beyond that you just need screaming fast database access.

Something like New Relic can give you some great insight into where the time is being spent (I expect it is a LOT of database queries, each of which completes reasonably fast but they probably add up).
Visit this user's website Find all posts by this user
Quote this message in a reply
11-27-2011, 09:45 AM
Post: #4
RE: Please help me improving First Byte Time
(11-27-2011 02:13 AM)pmeenan Wrote:  Your CDN servers should be correctly identified since they are on MaxCDN/NetDNA. Looking at the test results it looks like all of your content is served from http://www.47r-squad.com though which is why you are failing the CDN check: http://www.webpagetest.org/result/111121...use_of_cdn

Out of the technologies you list, only xcache could possibly help your first byte times for the base page (dynamic content).

There are a couple of posts about optimizing for vBulletin (I believe Marvin has done a lot of work on it) but it essentially comes down to turning off everything that isn't critical for your site in the options. Beyond that you just need screaming fast database access.

Something like New Relic can give you some great insight into where the time is being spent (I expect it is a LOT of database queries, each of which completes reasonably fast but they probably add up).

Hi there, thanks for replying.
edge.47r-squad.com is on edgecast cdn, could that be added so it detects it?

Would you go with MyISAM or InnoDB for database?

I'll take a look at New Relic, but it seems to be a very expensive piece of software.
Find all posts by this user
Quote this message in a reply
11-27-2011, 01:29 PM
Post: #5
RE: Please help me improving First Byte Time
New Relic has a 14-day free trial for the pro version and steps all the way down to a fully free (with less detail and data retention level). Hopefully you would be able to find a lot of issues to address in the trial period.

Edgecast should also be detected. All of the resources that were detected as not being served from a CDN were coming directly off of your www domain.

For a smaller database with not much concurrency you probably won't notice much difference between MyISAM and InnoDB but if you have a lot of concurrent reads and writes you probably want InnoDB for it's row-level locking (where last I checked MyISAM has to lock to full table for writes).
Visit this user's website Find all posts by this user
Quote this message in a reply
11-27-2011, 06:38 PM
Post: #6
RE: Please help me improving First Byte Time
Hmmm, I signed up but didn't get a free 14 day trial...
Find all posts by this user
Quote this message in a reply
11-29-2011, 01:08 PM
Post: #7
RE: Please help me improving First Byte Time
I was finally about to set this up and here is what it came up with:
http://img141.imageshack.us/img141/8469/slowqueries.png

Any suggestions on how I can tune up DB? or anything I can tell my web host to improve those times?
Find all posts by this user
Quote this message in a reply
11-30-2011, 04:24 AM
Post: #8
RE: Please help me improving First Byte Time
Hard to say without knowing the database architecture. It looks like a lot of the long operations were write operations so if you are using MyISAM you could be bumping into concurrency issues and could get a boost from a switch to innodb.

I hope that the user table already has an index on uid but if not you might need to add one there.

Those are just the traces from specific queries that took a long time, what do the graphs look like under app server->overview? Is database the main contributor to time or is it something else? What is the reported average response time?
Visit this user's website Find all posts by this user
Quote this message in a reply
11-30-2011, 10:11 AM
Post: #9
RE: Please help me improving First Byte Time
Looks like it might be vBSEO mainly, but that's tied into the database.
Here is a screenshot of overview: http://img221.imageshack.us/img221/2002/overviewm.png
Find all posts by this user
Quote this message in a reply
11-30-2011, 09:16 PM
Post: #10
RE: Please help me improving First Byte Time
Hi IcEWoLF,

I've been following your thread here and at vBSEO forum with great interest. I don't have anything helpful to add as far as troubleshooting or optimization, but your issue has prompted me to perform a test of my site, which is similar to yours in the add-ons used (vBSEO, vBadvanced, but I run the old vB3.8.x instead of the new vB4.x).

I did 10 tests with vBSEO enabled, and 10 tests with vBSEO disabled. When comparing the results of the 2 median runs, the TTFB was only just over 10 milliseconds slower with vBSEO enabled.

I'm also on a VPS.

Marvin
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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