Den 2012-02-13 21:16 skrev nathanelrick s�h�r:

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

First, stop worrying about the disk space being wasted. That's a problem
for Access and similar. "Real" database managers don't suffer from that
kind of problem. Period

Based on my experience, it is usually a lot faster to drop a table and
recreate it, than to delete all the records. I'd recommend you use that
approach to clean it out each night.

Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



[Non-text portions of this message have been removed]