[Theforum] [---Dev] RE: [---tent] Article cleanup issue
Martin Burns
martin at easyweb.co.uk
Tue Jul 23 18:15:20 CDT 2002
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
More information about the theforum
mailing list