[thesite] Caching Questions

.jeff jeff at members.evolt.org
Wed Jan 9 15:31:16 CST 2002


> From: Michele Foster
> For my own information .. I'm just wondering about the
> caching of the front page on teo and what exactly it is
> doing.

just the queries themselves are being cached so they don't have to be run
*everytime* the page is loaded/reloaded.

> I posted a new comment, and it doesn't show up right
> away.  I also noticed it the other day that the front
> page indicated a certain number of ratings for a
> particular article, yet when I viewed the article there
> were more ratings.
> How long is the caching?  Is it just teo or will this
> also appear on weo?  Will the delays be as noticeable
> on weo, since its a better optimized machine(s) and
> DB?  I understand our desire to get that homepage
> loading quicker.  I'm just curious as to what's going
> on behind the scenes.

so long as the text of the sql query doesn't change and there's a hit to the
page within the specified timeout (20 minutes i believe, though i could be
wrong.  it might actually be shorter) then it will use the resultset that's
cached.  however, if either the text of the sql changes or the page isn't
called within the timeout, it will go to the database to get a fresh
resultset and the process starts over.

make sense?


jeff at members.evolt.org

More information about the thesite mailing list