Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 26709 invoked from network); 31 May 2010 16:56:31 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 31 May 2010 16:56:31 -0000 Received: (qmail 69064 invoked by uid 500); 31 May 2010 16:56:30 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 69007 invoked by uid 500); 31 May 2010 16:56:30 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 68999 invoked by uid 99); 31 May 2010 16:56:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 May 2010 16:56:30 +0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [212.27.42.3] (HELO smtp3-g21.free.fr) (212.27.42.3) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 May 2010 16:56:22 +0000 Received: from [192.168.0.2] (eur10-1-82-241-180-211.fbx.proxad.net [82.241.180.211]) by smtp3-g21.free.fr (Postfix) with ESMTP id 11BD7818211 for ; Mon, 31 May 2010 18:55:52 +0200 (CEST) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Apple Message framework v1078) Subject: Re: Question on selecting on reduce values From: =?iso-8859-1?Q?Aur=E9lien_B=E9nel?= In-Reply-To: <4177CCE1-D933-42F8-8DFC-39DC88725EF5@gmail.com> Date: Mon, 31 May 2010 18:55:51 +0200 Content-Transfer-Encoding: quoted-printable Message-Id: <59090805-961A-40F3-A1F0-7B029CE08C7F@utt.fr> References: <3D7954B0-4F5C-4E4F-895E-0DF1FBEB821E@utt.fr> <4177CCE1-D933-42F8-8DFC-39DC88725EF5@gmail.com> To: user@couchdb.apache.org X-Mailer: Apple Mail (2.1078) Good evening, > try replacing the reduce function with the single word string "_count" = (Without the quotes) > this will do it in Erlang, and should speed things up a lot. please = let us know what kind of difference this makes. Wow! Indeed! It went from 13 seconds to 1second!!! Maybe I should learn erlang ;) Thank you very much for your help. Two comments though: 1. It took me some time to understand that a noeol file had to be done = if we wanted couchapp to work with _sum and _count. Is it documented = anywhere? 2. I'm a bit confused by the impact of views implementation on request = time. Isn't couchdb supposed to cache partial reduce results (like it = does for map results)? Regards, Aur=E9lien=