incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Davis" <paul.joseph.da...@gmail.com>
Subject Re: slow views
Date Sun, 21 Dec 2008 04:26:54 GMT
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
View raw message