cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohit Anchlia <mohitanch...@gmail.com>
Subject Re: Schema advice: (Single row or multiple row!?) How do I store millions of columns when I need to read a set of around 500 columns at a single read query using column names ?
Date Mon, 23 Jul 2012 17:49:00 GMT
On Mon, Jul 23, 2012 at 10:07 AM, Ertio Lew <ertiop93@gmail.com> wrote:

> My major concern is that is it too bad retrieving 300-500 rows (each for a
> single column) in a single read query that I should store all these(around
> a hundred million) columns in a single row?


You could create multiple rows and each row with around 1k-2k columns
depending on how big your columns are. I definitely suggest running some
tests? Is this timeseries data or event type data?

Mime
View raw message