Re: Storage format

2010-03-01 Thread Erik Holstad
Sorry about that! Continuing: And in that case when using rows as indexes instead of columns we only need to read that specific row and might be more efficient in that case than to read a big row every time? -- Regards Erik

Re: Storage format

2010-03-01 Thread Jonathan Ellis
On Mon, Mar 1, 2010 at 4:06 PM, Erik Holstad erikhols...@gmail.com wrote: So that is kinda of what I want to do, but I want to go from a row with multiple columns to multiple rows with one column Right, and I'm trying to tell you that this is a bad idea unless you are worried about exhausting

Re: Storage format

2010-03-01 Thread Jonathan Ellis
On Mon, Mar 1, 2010 at 4:49 PM, Erik Holstad erikhols...@gmail.com wrote: Haha! Thanks. Well I'm z little bit worried about this but since the indexes are pretty small I don't think it is going to be too bad. But was mostly thinking about performance and and having the index row as a

Re: Storage format

2010-03-01 Thread Erik Holstad
On Mon, Mar 1, 2010 at 2:51 PM, Jonathan Ellis jbel...@gmail.com wrote: On Mon, Mar 1, 2010 at 4:49 PM, Erik Holstad erikhols...@gmail.com wrote: Haha! Thanks. Well I'm z little bit worried about this but since the indexes are pretty small I don't think it is going to be too bad. But

Re: Storage format

2010-03-01 Thread Jonathan Ellis
Then you definitely want one row, range queries are slower than we'd like right now. (Ticket to fix that: https://issues.apache.org/jira/browse/CASSANDRA-821) On Mon, Mar 1, 2010 at 5:00 PM, Erik Holstad erikhols...@gmail.com wrote: On Mon, Mar 1, 2010 at 2:51 PM, Jonathan Ellis