incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alex kamil <alex.ka...@gmail.com>
Subject Sparse vs dense index
Date Tue, 16 Mar 2010 17:15:19 GMT
which index structure would fit Cassandra more naturally and perform better:
1) a sparse index where in each row there are 100 columns each containing a
5MB data block (under a single column family)
or
2) a dense index where  each row contains 100 columns with a single 6bytes
value (under a single column family)

- assuming the total data size is 30-50TB, 500GB appends per day
-  the data is time series (output from a multichannel EEG sensor)
the key performance metric for us is read throughput (random reads/sec,
range queries, sequential scans)

Thanks
Alex

Mime
View raw message