Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of webjogger@gmail.com designates
 72.14.252.156 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=jo7Drov/5VEAx2GnyfQc4xPCEfJLutxbB5R0AkrMznc0eQv+MuFCPga9ehgCbvwJB6
         IZHHogomDU6cq7OhvtBryQ9lu1GV/w1BMTnaWQWP1JgoiDixDXa+VFiX41tDmbS0dAe5
         PIQkFEFwYjFylrVfpDQQjMVNRykKri+5aOrmI=
Message-ID: <4c69d7170812202024o53f220f9g155d5bf3cad80e73@mail.gmail.com>
Date: Sat, 20 Dec 2008 20:24:44 -0800
From: "paul jobs" <webjogger@gmail.com>
To: user@couchdb.apache.org
Subject: Re: slow views
In-Reply-To: <4c69d7170812202020y7054733at9d9c51465412ca44@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_53736_21320389.1229833484559"
References: <4c69d7170812202004v5d3738b4x667201b0181e451f@mail.gmail.com>
	 <e2111bbb0812202016k1f04630ftb60c780e92e9f27@mail.gmail.com>
	 <4c69d7170812202020y7054733at9d9c51465412ca44@mail.gmail.com>

------=_Part_53736_21320389.1229833484559
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_53736_21320389.1229833484559--