From user-return-5304-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Fri Jun 26 09:35:42 2009 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 55123 invoked from network); 26 Jun 2009 09:35:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 26 Jun 2009 09:35:42 -0000 Received: (qmail 15298 invoked by uid 500); 26 Jun 2009 09:35:52 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 15230 invoked by uid 500); 26 Jun 2009 09:35:52 -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 15220 invoked by uid 99); 26 Jun 2009 09:35:52 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Jun 2009 09:35:52 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of b.candler@pobox.com designates 208.72.237.25 as permitted sender) Received: from [208.72.237.25] (HELO sasl.smtp.pobox.com) (208.72.237.25) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Jun 2009 09:35:43 +0000 Received: from localhost.localdomain (unknown [127.0.0.1]) by a-sasl-quonix.sasl.smtp.pobox.com (Postfix) with ESMTP id 8198E236FB; Fri, 26 Jun 2009 05:35:09 -0400 (EDT) Received: from mappit (unknown [80.45.95.114]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by a-sasl-quonix.sasl.smtp.pobox.com (Postfix) with ESMTPSA id 273D6236FA; Fri, 26 Jun 2009 05:35:07 -0400 (EDT) Received: from brian by mappit with local (Exim 4.69) (envelope-from ) id 1MK7pb-000318-Nl; Fri, 26 Jun 2009 10:34:51 +0100 Date: Fri, 26 Jun 2009 10:34:51 +0100 From: Brian Candler To: hhsuper Cc: user@couchdb.apache.org Subject: Re: 'Grouping' documents so that a set of documents is passed to the view function Message-ID: <20090626093451.GA11503@uk.tiscali.com> References: <69a992ac0906240335n1a6ec400we8e7831f0b46947d@mail.gmail.com> <20090624154301.GA27351@uk.tiscali.com> <69a992ac0906241824n32d1f6a5r334346db02d4a065@mail.gmail.com> <20090625083431.GA7022@uk.tiscali.com> <20090625090839.GA7316@uk.tiscali.com> <69a992ac0906251939m712f5e8cnb13fa458685306a@mail.gmail.com> <69a992ac0906252232y5af167d5g6a44a125c514d56b@mail.gmail.com> <20090626071538.GB6767@uk.tiscali.com> <69a992ac0906260201o6878be83v8df68e21f4b7ec03@mail.gmail.com> <69a992ac0906260213rf4a9c51j58753280b490c556@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <69a992ac0906260213rf4a9c51j58753280b490c556@mail.gmail.com> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Pobox-Relay-ID: A3E4CF54-6234-11DE-AD55-DC021A496417-28021239!a-sasl-quonix.pobox.com X-Virus-Checked: Checked by ClamAV on apache.org On Fri, Jun 26, 2009 at 05:13:18PM +0800, hhsuper wrote: > by the way, we select to use couchdb as a part our current application, > because that part of data is huge and with everyday got growth, we need > do some analysis on these data and then give the result back to the > user( though our website), maybe i need consider another solution: > analysis still with couchdb view, but not query that directly to the > web, we maybe give a cron job sync the analysis(couchdb view) data to a > mysql table and then use the result data in mysql table to feed the > webpage, that is easy to paging and sorting at mysql level, this is a > rough thought only. Yep, we seem to have had the same idea. Or maybe it may make sense to perform the analysis or partial analysis when exporting, and stick the summarised data into another couchdb database which is searched via the web.