Re: [Slashcode-development] (no subject)

[shane <sh...@lo...>]

At 01:04 AM 4/6/2001 -0400, you wrote:
>Hi,
>
>I need to know what determines the length of time a story remains in the
>table "newstories".  Is it a variable in the "vars" table?  Is it different
>for each section?  Does slashd move the stories out of "newstories" and into
>"stories"?

Take a look at slashd. I think it does the 'moving' from
newstories to stories.


>Why does "newstories" even exist?

I think it's to speed up the sql. If you've 2000 stories in the
'stories' table, and you've got the 10 latest stories in the
'newstories' table, then the db (for the majoriy of the hits
to the system) only has to waid through those few in the
newstories table, rather then polling the huge stories table.