incubator-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:24:44 GMT
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