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

[Martin Burns]

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
benefit..?

> 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
cached.

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?

Cheers
Martin

------------------------------------------------------------------------------
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