Re: Cassandra search performance

And I found, if I only have the search condition "status", it only scan 200 records. But if I combine another condition "partition" then it scan all records because "partition" condition match all records. But combine with other condition such as "userName", even all "userName" is same in the 1,0

Re: Cassandra search performance

what version of cassandra are you using. I found a big performance hit when querying on the secondary index. I came across this bug in versions prior to 1.1 https://issues.apache.org/jira/browse/CASSANDRA-3545 Hope that helps. 2012/4/25 Jason Tang > And I found, if I only have the search con

Re: Cassandra search performance

1.0.8 在 2012年4月25日 下午10:38，Philip Shon 写道： > what version of cassandra are you using. I found a big performance hit > when querying on the secondary index. > > I came across this bug in versions prior to 1.1 > > https://issues.apache.org/jira/browse/CASSANDRA-3545 > > Hope that helps. > > 2012/4

Re: Cassandra search performance

Jason, I'm using plenty of secondary indexes with no problem at all. Looking at your example,as I think you understand, you forgo indexes by combining two conditions in one query, thinking along the lines of what is often done in RDBMS. A scan is expected in this case, and there is no magic to av

Re: Cassandra search performance

On Sun, Apr 29, 2012 at 4:32 PM, Maxim Potekhin wrote: > Looking at your example,as I think you understand, you forgo indexes by > combining two conditions in one query, thinking along the lines of what is > often done in RDBMS. A scan is expected in this case, and there is no > magic to avoid it

Re: Cassandra search performance

Thanks for the comments, much appreciated. Maxim On 5/7/2012 3:22 AM, David Jeske wrote: On Sun, Apr 29, 2012 at 4:32 PM, Maxim Potekhin > wrote: Looking at your example,as I think you understand, you forgo indexes by combining two conditions in one query,

Re: Cassandra search performance

I try to search one column, this column store the time as the type Long, 1,000,000 data equally distributed in 24 hours, I only want to search certain time rang, eg from 01:30 to 01:50 or 08:00 to 12:00, but something stranger happened. Search 00:00 to 23:59 limit 100 It took less then 1 second sc

Re: Cassandra search performance

When you build a secondary index on a field, what happens is a second (hidden) column family is created for you, with the key for that column family being the value of the index field, and the columns being the keys of the entries in your column family that have that value. So in your case, you ma