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

[.jeff]

martin,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Martin Burns
>
> ...much of which doesn't seem to be needed if the vast
> majority of people only browse the 1st few pages
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

wrong.

everyone that logs in the same day and views the site within the timespan window keeps that query cached.  therefore the caching effectively benefits everyone except those that surf the site not logged in.

it also benefits you anytime you return to the homepage.

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > all queries would take longer
>
> How much longer? A wee bit? Or 5000ms?
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

twice as long or more to execute everything.

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

homepage and category pages would be affected.

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

partially true.

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

only if the query doesn't have any criteria based on the user's request, like date last logged in like the query has now.  then a bot couldn't cache it and have it be relevant or accurate.

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/