incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antony Blakey <antony.bla...@gmail.com>
Subject Re: slow views
Date Sun, 21 Dec 2008 04:32:39 GMT

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).

>
>
> 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