Can you provide some more information on the query you are running ? How many terms are you selecting with?
How long does it take to return 1024 rows ? IMHO thats a reasonably big slice to get. The server will pick the most selective equality predicate, and then filter the results from that using the other predicates. Cheers ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 21 Jun 2011, at 09:04, Wojciech Pietrzok wrote: > Hello, > > I've noticed that queries using secondary indexes seems to be getting > rather slow. > Right now I've got an Column Family with 4 indexed columns (plus 5-6 > non indexed columns, column values are small), and around 1,5-2 > millions of rows. I'm using pycassa client and query using > get_indexed_slices method that returns over 10k rows (in batches of > 1024 rows) can take up to 30 seconds. Is it normal? Seems too long for > me. > > Maybe there's a way to tune Cassandra config for better secondary > indexes performance? > > Using Cassandra 0.7.6 > > -- > KosciaK
