#2. Performance: Will Cassandra work better with a single keyspace
+ lots of
keys, or thousands of keyspaces?
Thousands is a non-starter. There is an active memtable for every CF
defined and caches (row and key) are per CF. Assuming even 2 CFs per
keyspace, with 4000 keyspaces you will have 8000 active memtables,
8000 _sets_ of sstables to be compacted, etc. Put everyone in the
same keyspace, use a prefix on keys to distinguish different clients.
So if I read this right, using lots of CF's is also a Bad Idea(tm)?
/Janne
