Re: composite query performance depends on component ordering

2012-04-03 Thread Alexandru Sicoe
Hi Sylvain and Aaron, Thanks for the comment Sylvain, what you say makes sense, I have microsecond precision timestamps and looking at some row printouts I see everything is happening at a different timestamp which means that it won't compare the second 100 bytes component. As for the methodology

Re: composite query performance depends on component ordering

2012-03-31 Thread aaron morton
Can you post the details of the queries you are running, including the methodology of the tests ? (Here is the methodology I used to time queries previously http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/) Cheers - Aaron Morton Freelance Developer @aaronmorton htt

Re: composite query performance depends on component ordering

2012-03-30 Thread Sylvain Lebresne
When you do a query, there's a lot of comparison happening between what's queries and the column names. But the composite comparator is lazy in that when it compares two names, if the first component are not equal, it doesn't have to compare the second one. So What's likely happening is that in the