The queries that involve running through the entire dband counting star signs or sex takes time yes. i think paul i got the point you are trying to make, by preparing a permanent view in the design document is all the info couchdb needs, there is no other stuff to make it faster
On Sat, Dec 20, 2008 at 8:26 PM, Paul Davis <[email protected]>wrote: > I have no idea what this means. > > On Sat, Dec 20, 2008 at 11:24 PM, paul jobs <[email protected]> wrote: > > Key > > Value *null*38822*""*263251*"female"*615820*"male"*538011 > > Same applies for this view too, these are the number of users in our app > and > > their sex > > map: function(doc) { emit(doc.sex, 1) } > > > > reduce: function(keys, values) { return sum(values)} > > > > On 12/20/08, paul jobs <[email protected]> wrote: > >> > >> it is a permanent viewbut every repeat request takes time as new users > are > >> constantly added to the db > >> > >> On Sat, Dec 20, 2008 at 8:16 PM, Paul Davis < > [email protected]>wrote: > >> > >>> If it's a temp view, no. > >>> > >>> If it's a permanent view, no. But *repeated* requests should be nearly > >>> instantaneous. > >>> > >>> That is all. > >>> > >>> On Sat, Dec 20, 2008 at 11:04 PM, paul jobs <[email protected]> > wrote: > >>> > map: > >>> > function(doc) { emit(doc.zodiac, 1) } > >>> > reduce: > >>> > function(keys, values) { return sum(values)} > >>> > > >>> > > >>> > Key > >>> > Value *null*149877*"aquarius"*98747*"aries"*103072*"cancer"*104318* > >>> > > "capricorn"*97605*"gemini"*103708*"leo"*107982*"libra"*104955*"pisces"* > >>> > 101741*"sagittarius"*92975 > >>> > > >>> > total number of records ~2 million > >>> > > >>> > this query takes quite some time to run > >>> > is there any way to make this query run faster > >>> > > >>> > thanks > >>> > > >>> > >> > >> > > >
