Re: Performance overhead when using start and end columns

2012-03-26 Thread R. Verlangen
@Aaron: Very interesting article! Mentioned it on my Dutch blog. 2012/3/26 Mohit Anchlia > Thanks! > > > On Mon, Mar 26, 2012 at 10:53 AM, aaron morton wrote: > >> See the test's in the article. >> >> The code I used for profiling is also available. >> >> Cheers >> >>- >> Aar

Re: Performance overhead when using start and end columns

2012-03-26 Thread Mohit Anchlia
Thanks! On Mon, Mar 26, 2012 at 10:53 AM, aaron morton wrote: > See the test's in the article. > > The code I used for profiling is also available. > > Cheers > >- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 27/03/2012, at 6:21 A

Re: Performance overhead when using start and end columns

2012-03-26 Thread Data Craftsman
Hi Aaron, Thanks for the benchmark. The matrix is valuable. Thanks, Charlie (@mujiang) 一个 木匠 === Data Architect Developer http://mujiang.blogspot.com On Mon, Mar 26, 2012 at 10:53 AM, aaron morton wrote: > See the test's in the article. > > The code I used for profiling is also available.

Re: Performance overhead when using start and end columns

2012-03-26 Thread aaron morton
See the test's in the article. The code I used for profiling is also available. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/03/2012, at 6:21 AM, Mohit Anchlia wrote: > Thanks but if I do have to specify start and end columns then

Re: Performance overhead when using start and end columns

2012-03-26 Thread Mohit Anchlia
Thanks but if I do have to specify start and end columns then how much overhead roughly would that translate to since reading metadata should be constant overall? On Mon, Mar 26, 2012 at 10:18 AM, aaron morton wrote: > Some information on query plans > http://thelastpickle.com/2011/07/04/Cassandr

Re: Performance overhead when using start and end columns

2012-03-26 Thread aaron morton
Some information on query plans http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/ Tl;Dr; Select columns with no start, in the natural Comparator order. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/03/2012, at 2:25 PM, Mohi

Performance overhead when using start and end columns

2012-03-24 Thread Mohit Anchlia
I have rows with around 2K-50K columns but when I do a query I only need to fetch few columns between start and end columns. I was wondering what performance overhead does it cause by using slice query with start and end columns? Looking at the code it looks like when you give start and end column