[erlang-questions] Deleting millions of rows in mnesia

Bengt Kleberg <>
Fri Mar 2 07:29:01 CET 2007


On 2007-03-02 00:44, Anders Nygren wrote:
> 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 would be greatful i you filled a table and measured both ways and then 
email this list with the result. please include erlang version, 
operating system and hardware.


bengt
-- 
Those were the days...
    EPO guidelines 1978: "If the contribution to the known art resides
    solely in a computer program then the subject matter is not
    patentable in whatever manner it may be presented in the claims."



More information about the erlang-questions mailing list