Hi Paul --
Thanks for the reply. The rates are very constant. I'm seeing ~120ms
insert times on the production DB where this all started. Here's a
second POST (and a PUT, for good measure) to the same database:
[oat]$ time curl -X POST --data '{"_id":"999999", "guid":"918292819"}'
http://localhost:5984/freeq_brk%2F1/
{"ok":true,"id":"561ce26f6ec87c05f77a7124d0a267d9","rev":"3569556693"}
real 0m0.133s
user 0m0.004s
sys 0m0.000s
[oat]$ time curl -X PUT --data '{"_id":"999999", "guid":"918292819"}'
http://localhost:5984/freeq_brk%2F1/9999
{"ok":true,"id":"9999","rev":"560195410"}
real 0m0.129s
user 0m0.004s
sys 0m0.000s
The advice to move to 0.10.0 is well-taken, but probably a more
involved solution.
Brian
On Oct 12, 2009, at 9:51 PM, Paul Davis wrote:
On Tue, Oct 13, 2009 at 12:37 AM, Brian Karlak <[email protected]>
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
