[Theforum] [---Dev] RE: [---tent] Article cleanup issue

Martin Burns martin at easyweb.co.uk
Tue Jul 23 18:08:00 CDT 2002

On Tue, 23 Jul 2002, .jeff wrote:

> martin,
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > > so cfserver can cache it so subsequent hits in the
> > > timespan allotted for the cached query don't have to
> > > hit the database again.
> >
> > How many subsequent hits are there for articles not in
> > the 1st page or 3?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> no idea, but that's not the only people that benefit from the caching.

But by caching more than we need to, they're the ones who have principle

> if you and i are both logged in today, we'd both benefit from the query
> caching because everything about the query is the same.  the same holds
> true for any other user visiting the homepage and logged in today.
> so long as all the hits occur in the timespan allotted for the cached
> query, they all get the page back lightning quick because the display
> can be built from a query in memory.

...much of which doesn't seem to be needed if the vast majority of people
only browse the 1st few pages

> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > If those hits weren't cached, what would be the impact
> > on:
> > 1) the visitors to non-cached pages
> > 2) the query times on the front page(s)?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> all queries would take longer

How much longer? A wee bit? Or 5000ms?

> because every hit to the site would generate
> at least one or more database requests.

Only the index pages, surely, as the full article content hasn't been

And if only the first few index pages are regularly viewed, that's a lot
of data being returned without benefit.

Another thing to think about - if the purpose of having an occasional
slow query is to cache the data for the benefit of everyone else, why does
it have to be a real human user who suffers that delay? Why couldn't it be
(say) a bot scheduled on a cron job?


Also starring in fine email     | "Names, once they are in common use, quickly
productions such as             | become mere sounds, their etymology being
martin at easyweb.co.uk            | buried, like so many of the earth's marvels,
martin.p.burns at uk.pwcglobal.com | beneath the dust of habit." - Salman Rushdie

More information about the theforum mailing list