[erlang-questions] Deleting millions of rows in mnesia

Anders Nygren <>
Fri Mar 2 00:44:53 CET 2007


Hi
I have a mnesia table that collects some data during one month, and then
it should be cleared, in order to collect data for the next month.
The table could be up to 10 million rows.

What is the best way to clear the table?
- mnesia:clear_table/1
- delete and recreate the table

I suspect that clear_table/1 could give a bad bump in cpu and memory usage.

/Anders



More information about the erlang-questions mailing list