incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marijn Stollenga <m.stolle...@gmail.com>
Subject Re: slow deleting
Date Mon, 05 Oct 2009 15:47:53 GMT
delayed_commits did the trick! Why does that help and more imporantly  
what are the side-effects. Does it take more time before the documents  
are up to date?

On 5 okt 2009, at 17:35, Chris Anderson wrote:

> On Mon, Oct 5, 2009 at 8:29 AM, Marijn Stollenga <m.stollenga@gmail.com 
> > wrote:
>> When using a python script that calls curl to delete the objects,  
>> it remains
>> equally slow. Curl does not have that header problem right? Other  
>> ideas?
>>
>
> How many documents do you have? Does the deletion size vary with #  
> of docs?
>
> Try setting delayed_commits=true in your config and see if that helps.
>
> Chris
>
>>
>> On 5 okt 2009, at 17:14, Robert Newson wrote:
>>
>>> I haven't checked but it's conceivable that couchdb4j (since it uses
>>> httpclient) is issuing an "Expect: continue" header, and couchdb,
>>> until very recently, treated that (incorrectly) case-sensitively,
>>> causing an unnecessary wait for a timeout.
>>>
>>> A trace of http request/response headers for a single delete would
>>> confirm or deny that hypothesis.
>>>
>>> B.
>>>
>>> On Mon, Oct 5, 2009 at 4:04 PM, Marijn Stollenga <m.stollenga@gmail.com 
>>> >
>>> wrote:
>>>>
>>>> By the way, I use couchdb4j for interfacing with couchdb. I will  
>>>> try to
>>>> find
>>>> out if that is the problem.
>>>>
>>>> On 5 okt 2009, at 16:36, Paul Davis wrote:
>>>>
>>>>> Views won't affect deletion speeds at all. What version of  
>>>>> CouchDB on
>>>>> what operating system are you using? Also, if possible you'll  
>>>>> want to
>>>>> group as many deletes as possible into a single _bulk_docs call.
>>>>>
>>>>> Regardless of _bulk_docs, 4rps seems slow if you're on one of the
>>>>> releases. If you're on an older version of trunk, try updating  
>>>>> to the
>>>>> current version to see if that helps out.
>>>>>
>>>>> Paul Davis
>>>>>
>>>>> On Mon, Oct 5, 2009 at 9:58 AM, Marijn Stollenga <m.stollenga@gmail.com

>>>>> >
>>>>> wrote:
>>>>>>
>>>>>> Hello,
>>>>>> I am new to this mailinglist. I am using CouchDB as backend to an
>>>>>> online
>>>>>> game. I notice that deleting documents is really slow (about 4  
>>>>>> deletes
>>>>>> per
>>>>>> second). Is there any way to improve this speed?
>>>>>> I use several views, do these views prohibit fast deletion? I  
>>>>>> added a
>>>>>> view
>>>>>> is use in the database.
>>>>>>
>>>>>> Thanks in advance,
>>>>>> Marijn
>>>>>>
>>>>>> {
>>>>>>  "all": {
>>>>>>     "map": "function(doc) {if (doc.type == 'area'){emit(doc.name,
>>>>>> doc._id);}}"
>>>>>>  },
>>>>>>  "to_character": {
>>>>>>     "map": "function(doc) {if (doc.type ==
>>>>>> 'character'){emit(doc.location,
>>>>>> doc.name);}}"
>>>>>>  },
>>>>>>  "to_paths": {
>>>>>>     "map": "function(doc) {if (doc.type == 'path'){emit(doc.from,
>>>>>> doc.to);}}"
>>>>>>  },
>>>>>>  "path_to_area": {
>>>>>>     "map": "function(doc) {if (doc.type == 'path'){emit 
>>>>>> (doc.from +
>>>>>> doc.name, doc.to);}}"
>>>>>>  }
>>>>>> }
>>>>
>>>>
>>
>>
>
>
>
> -- 
> Chris Anderson
> http://jchrisa.net
> http://couch.io


Mime
View raw message