On Tue, Oct 13, 2009 at 1:06 AM, Brian Karlak <[email protected]> wrote: > 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 > >
Brian, Have you compacted your production DB recently? Paul
