Re: order of index expressions

2011-02-07 Thread Shaun Cutts
Jonathan, Thanks for your thoughts > On Sun, Feb 6, 2011 at 11:03 AM, Shaun Cutts wrote: >> What I think you should be doing is the following: open iterators on the >> matching keys for each of the indexes; the inside loop would pick an >> iterator at random, and pull a match from it. This

Re: order of index expressions

2011-02-07 Thread Jonathan Ellis
On Sun, Feb 6, 2011 at 11:03 AM, Shaun Cutts wrote: > What I think you should be doing is the following: open iterators on the > matching keys for each of the indexes; the inside loop would pick an iterator > at random, and pull a match from it. This would assure that the expected > number of e

Re: order of index expressions

2011-02-06 Thread Shaun Cutts
; I have 7.0rc2 installed). >> >> I was also wondering where the code that does this is... is it in >> >> java.org.apache.cassandra.db.columniterator.IndexedSliceReader? >> >> >> Thanks, >> >> -- Shaun >> >> On Feb 5, 2011, at 2:39 PM, Jonath

Re: order of index expressions

2011-02-05 Thread Jonathan Ellis
b 5, 2011, at 2:39 PM, Jonathan Ellis wrote: > >> On Sat, Feb 5, 2011 at 8:48 AM, Shaun Cutts wrote: >>> Hello, >>> I'm wondering if cassandra is sensitive to the order of index expressions in >>> (pycassa call) get_indexed_slices? >> >>

Re: order of index expressions

2011-02-05 Thread Shaun Cutts
andra is sensitive to the order of index expressions in >> (pycassa call) get_indexed_slices? > > No. > >> If I have several column indexes available, will it attempt to optimize the >> order? > > Yes. > > -- > Jonathan Ellis > Project Chair, Apache Cas

Re: order of index expressions

2011-02-05 Thread buddhasystem
Jonathan, what's the implementation of that? I.e. is is a product of indexes or nested loops? Thanks, Maxim -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/order-of-index-expressions-tp5995909p5996488.html Sent from the cassan

Re: order of index expressions

2011-02-05 Thread Jonathan Ellis
On Sat, Feb 5, 2011 at 8:48 AM, Shaun Cutts wrote: > Hello, > I'm wondering if cassandra is sensitive to the order of index expressions in > (pycassa call) get_indexed_slices? No. > If I have several column indexes available, will it attempt to optimize the > order? Yes.

order of index expressions

2011-02-05 Thread Shaun Cutts
Hello, I'm wondering if cassandra is sensitive to the order of index expressions in (pycassa call) get_indexed_slices? If I have several column indexes available, will it attempt to optimize the order? Thanks, -- Shaun