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

[Martin Burns]

On Tue, 23 Jul 2002, .jeff wrote:

> the generated sql based on my last visit, in all its glory:
>
> SELECT content.contentid
>      , content.keyphrase
>      , content.contentname
>      , content.synopsis
>      , content.datemod
>      , content.replies
>      , content.rating
>      , content.ratings
>      , users.userid
>      , users.who
>      , categorys.category
>      , categorys.categoryid
>      , (SELECT Count(*)
>           FROM replies
>          WHERE contentid = content.contentid
>            AND datemod > '22-Jul-02'
>        ) AS newcomments
>    FROM content
>       , users
>       , categorys
>   WHERE content.signoff = 1
>     AND content.categoryid <> 23
>     AND content.categoryid <> 26
>     AND content.categoryid <> 9741
>     AND content.userid = users.userid
>     AND content.categoryid = categorys.categoryid
>   ORDER BY content.datemod DESC
>       , content.contentid DESC

Right. So (excuse my SQL ignorance) is that returning pretty
much everything about every signed off article in the db except:
1) certain categories (eg jobs)
2) the full article content

> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > And other than building the 1st page worth of
> > title/synopsis etc, what is it being returned for?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> 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?

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

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