Re: Why Secondary indexes is so slowly by my test?

2012-12-13 Thread Chengying Fang
I do missed this important article about index, which discussing about the focus concerns. In fact, I have used Composite Column to resolve my problem. In some context, data model can resolves as 'alternate index', but it's complicated and can result new problems: data redundancy and maintenanc

Re: Why Secondary indexes is so slowly by my test?

2012-12-12 Thread Chengying Fang
y capability on top of cassandra ;)??.it works for us. Dean From: Chengying Fang mailto:cyf...@ngnsoft.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Tuesday, December 11, 2012 8:22 PM To: user mail

Re: Why Secondary indexes is so slowly by my test?

2012-12-11 Thread Chengying Fang
ing into indexed CFs will be slower (but will get substantially faster in 1.2 due to CASSANDRA-2897). If you need to retrieve large amounts of data with your query, you would be better off changing your data model to not use secondary indexes. Richard. On 7 December 2012 03:08, Chengying F

Why Secondary indexes is so slowly by my test?

2012-12-06 Thread Chengying Fang
Hi guys, I found Secondary indexes too slowly in my product(amazon large instance) with cassandra, then I did test again as describe here. But the result is the same as product. What's wrong with cassandra or me? Now my test: newly installed ubuntu-12.04 LTS , apache-cassandra-1.1.6, default co