Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 34383 invoked from network); 3 Nov 2009 21:50:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Nov 2009 21:50:38 -0000 Received: (qmail 87300 invoked by uid 500); 3 Nov 2009 21:50:37 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 87248 invoked by uid 500); 3 Nov 2009 21:50:36 -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 87238 invoked by uid 99); 3 Nov 2009 21:50:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Nov 2009 21:50:36 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kolosy@gmail.com designates 74.125.78.24 as permitted sender) Received: from [74.125.78.24] (HELO ey-out-2122.google.com) (74.125.78.24) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Nov 2009 21:50:26 +0000 Received: by ey-out-2122.google.com with SMTP id 22so1380162eye.41 for ; Tue, 03 Nov 2009 13:50:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to :content-type; bh=barq5sdzfmNWbF4BaL7EOy0khWTaLnN/QdDi4dr5BSA=; b=mqe99bGQwGJ05TNODqU7M28gZhjMN3TfAhOtzCSTV5NR7bD42T2AWf08OOB1e/V7kN +CvesaeZkYzaIjgrWq2VItRbN6qic+tnkdHR5Fby9RZoiT56N0gnoQb59j3noIIQMAtc HaUcfkm4VnAQjLZIoE096oMlGv3CdH/HtEAfw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type; b=OHNbyUaAFGDL+tfmW4hTtBtvntT3il2Yu+LG8z+rGFG/SN9UfTqe5SxWQ5TQuw63KS QBwQ2Cm0CMeoZd3FNWbvZN42At3OLIZqsPBtstMNbNuBfIKLjC9cKuM87SeC/PcQpivI A4X/0R/F9IGCzoIflGFVN2BWasyZKCeXx7peg= MIME-Version: 1.0 Sender: kolosy@gmail.com Received: by 10.213.2.71 with SMTP id 7mr668623ebi.68.1257285005921; Tue, 03 Nov 2009 13:50:05 -0800 (PST) In-Reply-To: <-9099098845468635477@unknownmsgid> References: <20091103112815.204461ityte0usw8@webmail.df.eu> <-9099098845468635477@unknownmsgid> Date: Tue, 3 Nov 2009 15:50:05 -0600 X-Google-Sender-Auth: ac4f9aff0d48f494 Message-ID: <8098243e0911031350nfb9828cpdc618fd4c3061b07@mail.gmail.com> Subject: Re: Performance issue From: Alex P To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=00151747680c28d1fb04777e7ae1 X-Virus-Checked: Checked by ClamAV on apache.org --00151747680c28d1fb04777e7ae1 Content-Type: text/plain; charset=ISO-8859-1 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 > > > > > --00151747680c28d1fb04777e7ae1--