On Tue, Apr 20, 2010 at 9:08 PM, Nick Poulden <[email protected]> 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.
