[erlang-questions] Mnesia table per user?
Tue Nov 28 00:14:38 CET 2006
Den 2006-11-27 16:37:35 skrev Pat e <patrickerj@REDACTED>:
> I am thinking about using Partition Attributes Across (PAX) modeling
> for our db.
> Now besides using mutual attributes for all users (gender, address,
> .....) we are thinking about using a table for each customer forum
> comments, blogs, personal correspondence....
That is certainly elegant in some ways, but...
> Now would it be resource wise to have table with binary data in it for
> each user, counting by 100,000 - 1MM users??
For that many users, you won't be able to have a table each.
Each erlang node is limited to around 50,000 ets tables
(the limit is configurable, but that's the ballpark, I think.
In the old days, there were some parts in the ets code that
would actually do a linear seach through the table of tables.)
Also, mnesia will do fine with a few thousand tables, but
will probably be in deep trouble with a million. The table
loading code is not designed for that.
More information about the erlang-questions