[erlang-questions] 64-bit fragmented mnesia table benefits?
Tue Mar 25 22:54:36 CET 2008
We used to run quite a substantial fragmented database ( about 250 milion
entries spread around 512 fragments) on DETS (disc-only copy), and do not
remember that memory was ever an issue (but then again, we had about 8GB of
RAM). However, when a particular fragment get populated beyond, say,
250,000 entries, insert and/or update of a particular table fragment (file)
suffers a considerable performance degradation.
As for recovery, well it could take quite some time, depending on size of
----- Original Message -----
From: "Christian S" <chsu79@REDACTED>
To: "Philip Robinson" <chlorophil@REDACTED>
Cc: "Erlang Questions" <erlang-questions@REDACTED>
Sent: Tuesday, March 25, 2008 4:49 PM
Subject: Re: [erlang-questions] 64-bit fragmented mnesia table benefits?
> On Tue, Mar 25, 2008 at 3:22 PM, Philip Robinson <chlorophil@REDACTED>
>> Hello all.
>> It is my understanding that using a 64-bit operating system pretty
>> much removes any of the size limitations for mnesia tables.
> The dets files still have their 32bit limitation.
> I've heard it rumoured here that dets have the following issues
> * when fragmented, the freelist is all in memory and occupies too much
> * recovery time for large files are unresonable long
> Are they true, as in, has it been a problem for anyone?
> How do solutions that perform better do?
> erlang-questions mailing list
More information about the erlang-questions