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 12:37:01 GMT
On Tue, Oct 13, 2009 at 1:06 AM, Brian Karlak <zenkat@metaweb.com> 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 <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
>
>

Brian,

Have you compacted your production DB recently?

Paul

Mime
View raw message