[erlang-questions] mnesia - secondary indexes vs separate tables
Tue May 28 14:26:01 CEST 2013
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...
More information about the erlang-questions