> it will probably be better to denormalize and store
> some precomputed data
Yes, if you know there are queries you need to serve it is better to support
those directly in the data model.
Cheers
-
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle
OK, got some results (below).
2 nodes, one on localhost, second on LAN, reading with
ConsistencyLevel.ONE, buffer_size=512 rows (that's how many rows
pycassa will get on one connection, than it will use last row_id as
start row for next query)
Queries types:
1) get_range - just added limit of 1024
tches 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
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
