On Mon, Oct 5, 2009 at 8:29 AM, Marijn Stollenga <[email protected]> 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 <[email protected]> >> 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 <[email protected]> >>>> 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
