RENAMING MNESIA TABES

Sean Hinde Sean.Hinde@REDACTED
Mon Dec 16 11:58:27 CET 2002


> We have a requirement to export some historical/log data from 
> MNESIA into
> ORACLE. The data in MNESIA table is short-lived, that is, 
> once the data has
> been exported, the MNESIA table is recreated (we find it much 
> faster to
> recreate a table than to use mnesia:clear_table/1).

Someone once posted a benchmark of nmesia:clear_table/1 using the unified
heap architecture - the time for I think 100k rows dropped from 10's of
seconds to sub 1 second.

It was something to do with memory locality. Might be worth a try.

Sean



NOTICE AND DISCLAIMER:
This email (including attachments) is confidential.  If you have received
this email in error please notify the sender immediately and delete this
email from your system without copying or disseminating it or placing any
reliance upon its contents.  We cannot accept liability for any breaches of
confidence arising through use of email.  Any opinions expressed in this
email (including attachments) are those of the author and do not necessarily
reflect our opinions.  We will not accept responsibility for any commitments
made by our employees outside the scope of our business.  We do not warrant
the accuracy or completeness of such information.




More information about the erlang-questions mailing list