Construct views that give you contiguous ranges for the queries you have. Be wary of doing a query over a much larger range and filtering out the rows you don't want, that might not scale when you have lots of docs.
B. On Thu, Jan 27, 2011 at 6:09 PM, Kenneth Tyler <[email protected]> wrote: > thanks, > ok, looks like i'll have to use something like couchbeam and process the > view results in erlang > > > ken tyler > > On Thu, Jan 27, 2011 at 9:27 AM, Robert Newson <[email protected]>wrote: > >> No, you can't do that. It's not a language limitation. A b+tree >> supports efficient key look up. It's also efficient to find the >> previous and next key when you do so. So couchdb provides contiguous >> range queries too. Your query can only be completed by a different, >> and more complicated, data structure than couchdb actually supplies. >> >> B. >> >> On Thu, Jan 27, 2011 at 5:21 PM, Kenneth Tyler <[email protected]> wrote: >> > If i want to select documents by values in certain parts of a key and >> ignore >> > other parts I don't think I can do that in couch using javascript views. >> > >> > If i have keys: a,3,b,4 -- a,2,c,1 -- a,5,b,2 >> > and i want to return keys that match a, _ , b, _ (where _ means "i don't >> > care") >> > can i do that if i switch to writing the views in erlang ? >> > >> > i know i could deal with this by writing a new view, whose key was made >> up >> > of the 1 and 3rd place values, >> > but what i want is a way to return rows from a view that contains the >> full >> > key by pattern matching >> > thanks >> > ken tyler >> > >> >
