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:45:15 GMT
On Sat, Dec 20, 2008 at 11:32 PM, Antony Blakey <antony.blakey@gmail.com> wrote:
>
> On 21/12/2008, at 2:54 PM, Paul Davis wrote:
>
>> View update times should be linear in terms of *new* records.
>
> Well, with a factor to deal with the reduction, which isn't O(n).
>

Kinda. I'm pretty sure they're still O(N), just not as pre calculated
as one might expect.

>>
>>
>> On Sat, Dec 20, 2008 at 11:20 PM, 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
>>>>>
>>>>
>>>
>
> Antony Blakey
> --------------------------
> CTO, Linkuistics Pty Ltd
> Ph: 0438 840 787
>
> Only two things are infinite, the universe and human stupidity, and I'm not
> sure about the former.
>  -- Albert Einstein
>
>

Mime
View raw message