couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirkjan Ochtman <dirk...@ochtman.nl>
Subject Re: Pruning a couchdb database
Date Mon, 27 Sep 2010 15:31:05 GMT
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

Mime
View raw message