From: "nathanelrick" <nathanelrick@...>

> Hello,
>
> I need to create a table where every days i will add around 2 000 000
> rows, to delete them every night (after compiling them to produce some
> statistics). so the table will receive around 60 000 000 rows every month
>
> I m afraid that this will cost a lot of IO on the hard drive and will slow
> all the systems ... also i m not sure that after i delete the row, the
> space will be mark as free for futur insert ... is it possible to keep
> this table in memory ? if not what i can do ?
>

Why not look at it from a different perspective. Instead of saving all the
records, computing the statistics and then deleting the records, why not
simply keep a running calculation based on available data? Or keep running
totals of what you need and compute the stats when needed? If the data isn't
going to be kept anyway, does it really matter if the records get saved? If
you update fields that keep running totals of available/needed information,
you can always run statistics based on those at any time.

Anyway, just a thought..

Woody (TMW)