incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ning Tan <ning...@gmail.com>
Subject Re: Intersecting several views
Date Wed, 21 Apr 2010 01:42:34 GMT
On Tue, Apr 20, 2010 at 9:08 PM, Nick Poulden <nick@domine.co.uk> wrote:
> My question is how to approach this filtering problem with couchdb. At the
> moment I have different views on 'account_type', 'registration_date' and
> 'last_login_date'. My program queries each view separately and returns an
> intersection of the resulting key arrays. This is working ok while my
> database is small but it's not very scalable as all the document keys have
> to be loaded in to memory before the intersection can happen.

For these "ad hoc" queries, I would suggest a separate indexing system
(e.g. Couch-Lucene, etc).

We use a Solr system for similar purposes.

Mime
View raw message