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

[Martin Burns]

On Tue, 23 Jul 2002, .jeff wrote:

> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > In addition, it'd be interesting to know how often under
> > the current procedure, this 10-second query actually
> > runs.  I had been led to believe that the maximum number
> > of times this would occur was once every 20 minutes for
> > a maximum of one user during that time frame?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> with one additional constraint -- provided nothing about that sql
> string changes from one request to the next.  one of the things that can
> change is the last logged in date for grabbing new comments since the last visit.
> that could be pulled out in to a separate query but would then have to
> be run inside the loop that displays the articles (triple yuck).

Question: While I can see that "new comments since last visit" is useful,
I'm not sure it's what it says on the tin. As a user, I've intuitively
associated that with "new comments in the last day", and been annoyed as
hell when comments have disappeared off that list when I wanted to go back
to them.

So my question is - why does this have to be queried on a per-user basis
when the main benefit ("See recent comments") isn't user-specific?

> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > If that's still true, I'm almost not seeing the issue,
> > though I do respect your wish to remove even that
> > minuscule bottleneck.
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> isn't it making more sense now why it's a bigger issue to me than others seem to think it should be?

Yes. You want it to be *right*. But isn't it also making sense why for
many/most people, 'good enough' is good enough?

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