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 <[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
