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 ?
