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
|