Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of paul.joseph.davis@gmail.com
 designates 209.85.211.204 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=YViRh0CcJWh7PD1D3TjPBlxnrRF1MywFUPNWwWFnoJIe/6UJ6Q6ZKkt4j0pMJI7fak
         kdUvBdmxPQPMlIsWPOCg89F5gbX6DRlfiA4O+61ocshhaCkhIk2FUuRrE6+kN5XclhlP
         mk0FOoINJsGA75EpMn2P8bDVsX73XqdxeHLvM=
MIME-Version: 1.0
In-Reply-To: <0FAC432A-E38E-40F8-AC79-0FB007DBC14D@gmail.com>
References: <0FAC432A-E38E-40F8-AC79-0FB007DBC14D@gmail.com>
Date: Mon, 5 Oct 2009 10:36:14 -0400
Message-ID: <e2111bbb0910050736l1b7cd29end130626503dfa49a@mail.gmail.com>
Subject: Re: slow deleting
From: Paul Davis <paul.joseph.davis@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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> wr=
ote:
> 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 pe=
r
> second). Is there any way to improve this speed?
> I use several views, do these views prohibit fast deletion? I added a vie=
w
> is use in the database.
>
> Thanks in advance,
> Marijn
>
> {
> =A0 "all": {
> =A0 =A0 =A0 "map": "function(doc) {if (doc.type =3D=3D 'area'){emit(doc.n=
ame,
> doc._id);}}"
> =A0 },
> =A0 "to_character": {
> =A0 =A0 =A0 "map": "function(doc) {if (doc.type =3D=3D 'character'){emit(=
doc.location,
> doc.name);}}"
> =A0 },
> =A0 "to_paths": {
> =A0 =A0 =A0 "map": "function(doc) {if (doc.type =3D=3D 'path'){emit(doc.f=
rom,
> doc.to);}}"
> =A0 },
> =A0 "path_to_area": {
> =A0 =A0 =A0 "map": "function(doc) {if (doc.type =3D=3D 'path'){emit(doc.f=
rom +
> doc.name, doc.to);}}"
> =A0 }
> }