Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 35977 invoked from network); 3 Nov 2009 21:59:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Nov 2009 21:59:30 -0000 Received: (qmail 92289 invoked by uid 500); 3 Nov 2009 21:59:28 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 92230 invoked by uid 500); 3 Nov 2009 21:59:28 -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 92219 invoked by uid 99); 3 Nov 2009 21:59:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Nov 2009 21:59:28 +0000 X-ASF-Spam-Status: No, hits=0.2 required=5.0 tests=AWL,BAYES_00,MSGID_MULTIPLE_AT,RCVD_IN_SORBS_WEB X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [89.36.166.90] (HELO mail.ro1-jdhosting.net) (89.36.166.90) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Nov 2009 21:59:26 +0000 Received: from LygosPC ([92.82.77.22]) by ro1-jdhosting.net with MailEnable ESMTP; Tue, 3 Nov 2009 23:58:24 +0200 From: "Sebastian Negomireanu" To: References: <20091103112815.204461ityte0usw8@webmail.df.eu> <-9099098845468635477@unknownmsgid> <8098243e0911031350nfb9828cpdc618fd4c3061b07@mail.gmail.com> In-Reply-To: <8098243e0911031350nfb9828cpdc618fd4c3061b07@mail.gmail.com> Subject: RE: Performance issue Date: Tue, 3 Nov 2009 23:59:40 +0200 Message-ID: <000601ca5cd0$f1325100$d396f300$@negomireanu@justdesign.ro> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Content-Language: en-us Thread-Index: Acpcz5iAHWx1l9x0STaOkl1UXcNFHAAAOJDA X-ME-Bayesian: 0.000000 This was initially my setup. I thought that maybe there's an issue with the windows release (because I know it didn't use to be fully supported). That was the reason I've tried to setup the Ubuntu VirtualBox machine to test the performance. In both scenarios I get the same results. I can only imagine there is a problem somewhere - either in the configuration or something more subtle and I cannot identify it. Best regards, Sebastian Negomireanu | CTO / Managing Partner JustDesign Sibiu, Romania +40-726-181186 | +40-788-757462 sebastian.negomireanu@justdesign.ro SC JustDesign SRL | Str. Dorului 20, 550352, Sibiu, Romania +40-269-210008 | office@justdesign.ro | www.justdesign.ro -----Original Message----- From: kolosy@gmail.com [mailto:kolosy@gmail.com] On Behalf Of Alex P Sent: Tuesday, November 03, 2009 11:50 PM To: user@couchdb.apache.org Subject: Re: Performance issue sebastian - try a windows-native build of couch, to eliminate the virtualization as a potential culprit. i've used [1] with good results thanks, alex. [1] http://markmail.org/message/jilbqz4jwt4xxsmw On Tue, Nov 3, 2009 at 3:35 PM, Sebastian Negomireanu < sebastian.negomireanu@justdesign.ro> wrote: > The issue is not sending documents in batches, but the extremely slow > insertion of individual documents. I think that a large amount of use cases > involve working with a single document instead of batches. There is no way > in the world an end user would cope with a 5 second response time for a > simple CRUD operation. > > > Best regards, > Sebastian Negomireanu | CTO / Managing Partner JustDesign Sibiu, Romania > +40-726-181186 | +40-788-757462 > sebastian.negomireanu@justdesign.ro > > SC JustDesign SRL | Str. Dorului 20, 550352, Sibiu, Romania > +40-269-210008 | office@justdesign.ro | www.justdesign.ro > > > -----Original Message----- > From: kosta@fillibach.de [mailto:kosta@fillibach.de] > Sent: Tuesday, November 03, 2009 12:28 PM > To: user@couchdb.apache.org; Sebastian Negomireanu > Subject: Re: Performance issue > > Hello, > > > I am encountering a big performance problem with CouchDB. I get > > response times around 500ms (and sometimes more). I've tried simple > > operations like adding a very minimal document (about 5 fields, a total > > payload of max 0.5 KB / doc). I've also tried the operation while running > it > > in a loop. After 220 seconds i've only PUT 448 documents. > > After running the whole thing through a profiler (to be sure that it's > not > > my code causing the issues), it seems the bottleneck is in the response > time > > from the couchdb server. > > Did you try batch=ok and bulk sending the documents? > > see http://wiki.apache.org/couchdb/HTTP_Document_API > and http://wiki.apache.org/couchdb/HTTP_Bulk_Document_API > > Kind regards, > Kosta > > > > >