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

2012-12-13 Thread Chengying Fang
ject: Re: Why Secondary indexes is so slowly by my test? Here is a good start. http://www.anuff.com/2011/02/indexing-in-cassandra.html On Thu, Dec 13, 2012 at 11:35 AM, Alain RODRIGUEZ wrote: Hi Edward, can you share the link to this blog ? Alain 2012/12/13 Edward Capriolo Ed ENuff s

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

2012-12-13 Thread Tyler Hobbs
If anyone's interested in a little more background on the read-before-write fix that Ed mentioned, see: https://issues.apache.org/jira/browse/CASSANDRA-2897 On Thu, Dec 13, 2012 at 11:31 AM, Edward Capriolo wrote: > Here is a good start. > > http://www.anuff.com/2011/02/indexing-in-cassandra.htm

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

2012-12-13 Thread Edward Capriolo
Here is a good start. http://www.anuff.com/2011/02/indexing-in-cassandra.html On Thu, Dec 13, 2012 at 11:35 AM, Alain RODRIGUEZ wrote: > Hi Edward, can you share the link to this blog ? > > Alain > > 2012/12/13 Edward Capriolo > >> Ed ENuff s > > >

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

2012-12-13 Thread Alain RODRIGUEZ
Hi Edward, can you share the link to this blog ? Alain 2012/12/13 Edward Capriolo > Ed ENuff s

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

2012-12-13 Thread Edward Capriolo
ns when doing query. Maybe I should redesign the CF model to fix it. > > -- Original -- > From: "Hiller, Dean"; > Date: Wed, Dec 12, 2012 10:51 PM > To: "user@cassandra.apache.org"; > Subject: Re: Why Secondary indexes is so s

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

2012-12-12 Thread aaron morton
eply-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 mailto:user@cassandra.apache.org>> > Subject: Re: Why Secondary indexes is so slowly by my test?

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

2012-12-12 Thread Chengying Fang
redesign the CF model to fix it. -- Original -- From: "Hiller, Dean"; Date: Wed, Dec 12, 2012 10:51 PM To: "user@cassandra.apache.org"; Subject: Re: Why Secondary indexes is so slowly by my test? You could always try PlayOrm's quer

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

2012-12-12 Thread Hiller, Dean
day, December 11, 2012 8:22 PM To: user mailto:user@cassandra.apache.org>> Subject: Re: Why Secondary indexes is so slowly by my test? Thanks to Low. We use CompositeColumn to substitue it in single not-equality and definite equalitys query. And we will give up cassandra because of the we

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

2012-12-11 Thread Chengying Fang
1, 2012 07:44 PM To: "user"; Subject: Re: Why Secondary indexes is so slowly by my test? Hi, Secondary index lookups are more complicated than normal queries so will be slower. Items have to first be queried in the index, then retrieved from their actual location. Also, insert

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

2012-12-11 Thread Richard Low
Hi, Secondary index lookups are more complicated than normal queries so will be slower. Items have to first be queried in the index, then retrieved from their actual location. Also, inserting into indexed CFs will be slower (but will get substantially faster in 1.2 due to CASSANDRA-2897). If yo

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