incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <paul.joseph.da...@gmail.com>
Subject Re: insert performance
Date Tue, 13 Oct 2009 04:51:27 GMT
On Tue, Oct 13, 2009 at 12:37 AM, Brian Karlak <zenkat@metaweb.com> wrote:
> Hello All --
>
> I am running CouchDB-0.8.1 on a dual-core Gentoo box.  Things have been
> smooth for several months, but suddenly I noticed that insert performance
> has decreased dramatically, even for an insert into a newly created
> database:
>
> # no database yet ...
> $ time curl -X POST --data '{"_id":"12345", "guid":"128736218763"}'
> http://localhost:5984/freeq_brk%2F1/
> {"error":"not_found","reason":"missing"}
> real    0m0.009s
> user    0m0.004s
> sys     0m0.004s
>
> # create a database
> $ time curl -X PUT http://oat.corp:5984/freeq_brk%2F1/
> {"ok":true}
> real    0m0.182s
> user    0m0.004s
> sys     0m0.004s
>
> # insert a document
> $ time curl -X POST --data '{"_id":"12345", "guid":"128736218763"}'
> http://localhost:5984/freeq_brk%2F1/
> {"ok":true,"id":"6cd41ba6ddfae66fc5f2f468c31411f1","rev":"3389439647"}
> real    0m0.117s
> user    0m0.004s
> sys     0m0.000s
>
> Can anyone provide me with any clues as to what might be going on, or even
> how to debug the situation?  This seems one or two orders of magnitude
> slower than I would expect -- or I remember seeing.
>
> Many thanks in advance for any advice anyone can provide.
>
> Brian

Brian,

Can you paste numbers for the second PUT on that database? Also, 0.8.1
hasn't been touched in about a year, so if you're noticing sudden
differences I'd wager a guess that its a system difference that's not
related to CouchDB.

In other news, we're just now releasing 0.10.0 which has some definite
performance gains if you're interested in upgrading. The API is
definitely different so it may take a bit of effort, but most client
libraries have since made the change.

HTH,
Paul Davis

Mime
View raw message