| Subject | Table where we add 2 000 000 rows everydays and delete them every night |
|---|---|
| Author | nathanelrick |
| Post date | 2012-02-13T20:16:02Z |
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 ?
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 ?