Re: Calculating the size of rows in KBs

2011-02-11 Thread Aklin_81
ANDRA-1956 > > On Fri, Feb 11, 2011 at 6:00 PM, buddhasystem wrote: >> >> Does it also mean that the whole row will be deserialized when a query >> comes >> just for one column? >> >> -- >> View this message in context: >> http://cassandra-user-incubator

Re: Calculating the size of rows in KBs

2011-02-11 Thread Stu Hood
the whole row will be deserialized when a query > comes > just for one column? > > -- > View this message in context: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Calculating-the-size-of-rows-in-KBs-tp6011243p6017870.html > Sent from the cassandra-u...@i

Re: Calculating the size of rows in KBs

2011-02-11 Thread buddhasystem
Does it also mean that the whole row will be deserialized when a query comes just for one column? -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Calculating-the-size-of-rows-in-KBs-tp6011243p6017870.html Sent from the cassandra-u

Re: Calculating the size of rows in KBs

2011-02-11 Thread Robert Coli
On Thu, Feb 10, 2011 at 12:24 PM, Aaron Morton wrote: > In general the entire row only exists in memory when it is contained in the > first Memtable it's written to. Or, somewhat importantly considering the serialization penalty paid to load it there, when it is in the Row Cache. As a simple ex

Re: Calculating the size of rows in KBs

2011-02-10 Thread Aaron Morton
If you are thinking about column_index_size_in_kb in Cassandra.yaml then yes. Aaron On 11/02/2011, at 9:39 AM, Aditya Narayan wrote: > Thank you Aaron!! > > But, If you are reading partial rows(that otherwise contain several > thousands of **valueless** columns) then do the column indexes hel

Re: Calculating the size of rows in KBs

2011-02-10 Thread Aditya Narayan
Thank you Aaron!! But, If you are reading partial rows(that otherwise contain several thousands of **valueless** columns) then do the column indexes help in making the reads faster & more efficient than if they were not valueless? Perhaps, because they would only need to look up whether the asked

Re: Calculating the size of rows in KBs

2011-02-10 Thread Aaron Morton
If you want to get the byte size of a particular row you will need to read it all back. If you connect with JConsole at look at you column families, there are attributes for the max, min and mean row sizes. In general the entire row only exists in memory when it is contained in the first Memta

Calculating the size of rows in KBs

2011-02-10 Thread Aditya Narayan
How can I get or calculate the size of rows/ columns ? what are the any overheads on memory for each column/row ?