Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of djc.ochtman@gmail.com
 designates 209.85.160.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:from:date
         :x-google-sender-auth:message-id:subject:to:content-type;
        b=sHbiXs2HHmtGdWgCNMLn+OmcZ560pNIYN8b1+5ENofSkl5SUl9SNJT4A/wLzqGaZ9W
         IXD62X5DXNn2e2ZxR/t7r5PIwBFHbGcvm23uKXQYJSXZGwvU7LrX75rxDgnX+7kCl/Ef
         Kb/QyM9XGVJUZFjGJpueO6Li3VHyhp74RgMH4=
MIME-Version: 1.0
Sender: djc.ochtman@gmail.com
In-Reply-To: <AANLkTimym7eFuqzSfnE0y3NRucZqMCqiWzgi-Dz7RgLv@mail.gmail.com>
References: <AANLkTimym7eFuqzSfnE0y3NRucZqMCqiWzgi-Dz7RgLv@mail.gmail.com>
From: Dirkjan Ochtman <dirkjan@ochtman.nl>
Date: Mon, 27 Sep 2010 17:31:05 +0200
Message-ID: <AANLkTimJBkUeRjBEBH1Nuf0c6=6oM0vOq_XbFg6X=F9k@mail.gmail.com>
Subject: Re: Pruning a couchdb database
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8

On Mon, Sep 27, 2010 at 17:26, John Logsdon <john.logsdon@netdev.co.uk> wrote:
> I need to hold, potentially, millions of call records in a couchdb cluster
> and using a management process periodically truncate the records based on
> their age. I can see how I can get the Set of matching records using a View
> but how do I delete them in the same operation? My understanding is that I
> can only GET from a View so I cant see how to do this without bringing the
> data back to the client and issuing a DELETE for each record which would be
> a real problem wrt performance.

Well, you don't need the fetch the data, but AFAIK you need to fetch
the document ID's and do a bulk update with {"_id": "foo", "_deleted":
true} for each document.

Cheers,

Dirkjan