[erlang-questions] mnesia - secondary indexes vs separate tables

[John Doe]

Hello,

I'm trying to do some kind of poor man's composite keys with mnesia for
some running statistical data. What should be faster to read and write -
one table with a few indexes or separate tables with primary key only?

There will be about 1-5 millions of records, approx the equal number of
reads, inserts and deletes.
The queries will be mostly "check if at least one record exists where given
indexed field value = ...", "insert ...", and "delete all records where
indexed field value=xxx". Total of 4 fields, so either one table with 4
indexed fields, or 4 tables with key_field + counter.
The table(s) will be disc_only_copy, as RAM matters.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20130528/21dd8138/attachment.htm>