Current time: 11-22-2019, 12:27 PM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Yet another time to first byte question
09-14-2011, 12:06 AM
Post: #8
RE: Yet another time to first byte question
It doesn't look like the database queries are actually getting cached:

Engine: apc
Total queries: 127
Cached queries: 0
Total query time: 0.4854

Try connecting to the site with a browser that isn't logged in just to make sure (cache is usually bypassed for logged in users).

With the size and number of things that it looks like your site needs cached you may also need to take a look at the APC diagnostics - if you're just using the default 32MB cache then I wouldn't be the least bit surprised if you've blown right through it.

By FAR, the most expensive queries to the database look to be the ad rotation tracking (the log has the time for each of the queries). Looks like every query that hits wp_adrotate_tracker takes 30ms and there are quite a few. Indexes might help but you might also be better off if you can move the ad rotation off of the back-end and have that be completely separate (a front-end-initiated request to dedicated code either as an iFrame or javascript ad code). If you move the ad rotation code off of the back end you will also be able to enable page caching for the base page.
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Yet another time to first byte question - pmeenan - 09-14-2011 12:06 AM

Forum Jump:


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