[erlang-questions] How many fragments would be proper for 1milions records in mensia?

Valentin Micic <>
Mon Jul 28 10:29:59 CEST 2008


I'd say that also depends on what storage method you're using. Thus, in a 
case you're planning to use DETS (disc_only_copy), you may want to consider 
fragmentation even for 1 million... In my experience, the performance 
deteriorates(*) when table gets populated beyond, say, 250,000 entries (if 
entries are reasonably complex terms).

In addition, if you increase a number of dets fragments, make sure that you 
also increase a number of I/O threads (+A) to some reasonable value(**).

V.

(*) Inserts and/or updates are affected, read seems to keep good performance 
levels.

(**) If you are using 32-bit environment, try not to get carried away with a 
number of I/O threads, as the cost in memory may be substantial.

----- Original Message ----- 
From: "Ulf Wiger" <>
To: "devdoer bird" <>; <>
Sent: Sunday, July 27, 2008 10:12 AM
Subject: Re: [erlang-questions] How many fragments would be proper for 
1milions records in mensia?


> Depending on object size, you may well have just a single
> table/fragment. 1 million objects is not that much.
>
> BR,
> Ulf W
>
> 2008/7/27, devdoer bird <>:
>> Hi:
>>
>> Considering the access  performance , easy mangement ,how many fragments
>> would be proper for 1 milions records in mensia? Are there any rules 
>> about
>> the number of fragments and the number of total records?
>>
>> Regards
>>
> _______________________________________________
> erlang-questions mailing list
> 
> http://www.erlang.org/mailman/listinfo/erlang-questions
> 




More information about the erlang-questions mailing list