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
