incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ganzha Alexey <tret...@gmail.com>
Subject 1 large view vs 2 smaller views
Date Sun, 24 Jul 2011 21:46:48 GMT
Hi.
I am trying figuring out whats the better.

Say i have a view:
...
    emit([doc.dep,doc.price,doc.date,doc._id]);
...

Some users need all docs. And some of them need only docs for the last week.
Just add an attribute 'last_week' in required documents.
Then, in the view i will check this attribute and there are 2 cases:

Filter docs in 1 view

emit(['THIS_IS_FOR_ALL',doc.dep,doc.price,doc.date,doc._id]);

if (doc.last_week)
   emit(['THIS_IS_FOR_LAST_WEEK_ONLY',doc.dep,doc.price,doc.date,doc._id]);

i will be able to query this view with the additional key member (will user
need all docs, or only last week docs)

Or make 2 separate views. First:

emit([doc.dep,doc.price,doc.date,'doc._id]);

and  Second:

if (doc.last_week)
    emit([doc.dep,doc.price,doc.date,doc._id])

First case will emit more keys, and the keys will be larger by 1 element.
But in second case, there are 2 views.

What would you prefer. What is the better for performance?
Thanks

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message