From user-return-15162-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Wed Mar 02 11:34:11 2011 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 6580 invoked from network); 2 Mar 2011 11:34:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Mar 2011 11:34:11 -0000 Received: (qmail 32639 invoked by uid 500); 2 Mar 2011 11:34:09 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 32529 invoked by uid 500); 2 Mar 2011 11:34:06 -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 32515 invoked by uid 99); 2 Mar 2011 11:34:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Mar 2011 11:34:05 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of rpettefar@gpslsolutions.com designates 207.5.75.31 as permitted sender) Received: from [207.5.75.31] (HELO mail31.intermedia.net) (207.5.75.31) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Mar 2011 11:33:57 +0000 Received: from [192.168.1.201] (host86-158-112-63.range86-158.btcentralplus.com [86.158.112.63]) (Authenticated sender: rpettefar@gpslsolutions.com) by mail31.intermedia.net (Postfix) with ESMTP id 2E71AA7111 for ; Wed, 2 Mar 2011 03:33:35 -0800 (PST) Message-ID: <4D6E2AF0.4070401@gpslsolutions.com> Date: Wed, 02 Mar 2011 11:33:04 +0000 From: Rob Pettefar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.8) Gecko/20100802 Lightning/1.0b2 Thunderbird/3.1.2 MIME-Version: 1.0 To: user@couchdb.apache.org Subject: View update speed improvements Content-Type: multipart/alternative; boundary="------------020003020905040005020402" --------------020003020905040005020402 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi guys I've got a question about improving the speed at which views are updated in our system: Currently we use a set of database documents to make up whole files after they have been requested out of the system. When submitted back into the database the old docs that held data are deleted and new docs are created in their place. This was done for simplicity of design. However when we have large file submitted into the system this will involve the deletion and creation of a large number of docs being deleted and created (we are looking at around 4,000 deletes and 4,000 new docs). The views then take some time to update after this has happened. If we were to instead, modify the contents of the 4,000 documents (perhaps with some deletions and creations) would this reduce the amount of updates the system would have to put though the views and thus, reduce the time needed to update the views? Thanks Rob --------------020003020905040005020402--