incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Karlak <zen...@metaweb.com>
Subject Re: insert performance
Date Tue, 13 Oct 2009 05:06:39 GMT
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 <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