couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "paul jobs" <webjog...@gmail.com>
Subject Re: slow views
Date Sun, 21 Dec 2008 04:37:56 GMT
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 <paul.joseph.davis@gmail.com>wrote:

> I have no idea what this means.
>
> On Sat, Dec 20, 2008 at 11:24 PM, paul jobs <webjogger@gmail.com> 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 <webjogger@gmail.com> 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 <
> paul.joseph.davis@gmail.com>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 <webjogger@gmail.com>
> 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
> >>> >
> >>>
> >>
> >>
> >
>

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