[GitHub] janl commented on issue #1202: [questions] Recommended way to delete huge number of documents.

[GitBox <gi...@apache.org>]

janl commented on issue #1202: [questions] Recommended way to delete huge number of documents.
URL: https://github.com/apache/couchdb/issues/1202#issuecomment-371181135
 
 
   In a case of ?this isn?t really what you?re asking for?, I?d recommend to re-think the need for this.
   
   1. if you want to clean up a database that has lots of docs you want to get rid of, but do it only once, I?d recommend doing a filtered replication of the docs that you want to keep and then delete the old database.
   2. if you want to keep a ?current? set of documents in the db, say delete everything older than 30/60/90 days, I?d recommend using a database per $interval.
   3. if you do need to do this regularly, preparing for CouchDB performance getting asymptotically worse. In this scenario, deleting in batches is the way to go.
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services