Mnesia and Oracle
Tue Aug 8 23:51:54 CEST 2006
I haven't had production experience with these databases, but there
are a couple of things I found by research that are keeping me from
using Mnesia exclusively in my application:
- Mnesia disc storage, based on dets, has a couple of drawbacks when
handling very large (many gigs) datasets: potentially long repair
times and memory consumption that grows with data fragmentation.
- QLC, the query engine for Mnesia, doesn't currently optimize joins.
If your queries involve joining big tables, they can take a long time
The join optimizations are planned for a future R11 OTP release, but
there are no plans to change dets AFAIK.
Depending on your application, these issues may not be a big problem.
For the application I'm building, I'm planning on using both MySQL and
Mnesia, where MySQL will be used for storing high-volume data and
Mnesia for "live" session data.
Hope this helps!
On 8/8/06, Inswitch Solutions <> wrote:
> I'm already working with Oracle and Mnesia, and I'd like to hear experiences of the Erlang community about these databases.
> When deciding over Oracle or Mnesia database for an Erlang, or non Erlang, based real-time system which factors are in favour in one over the other (performance...?) ?.
> thanks, Eduardo
> Prepaid Expertise - Programmable Switches
> Powered by Ericsson Licensed Technology
> Eng. Eduardo Figoli - Development Center - IN Switch Solutions Inc.
> Headquarters - Miami-U.S.A. Tel: 1305-3578076 Fax: 1305-7686260
> Development Center - Montevideo - Uruguay Tel/Fax: 5982-7104457
More information about the erlang-questions