[GitHub] style95 opened a new issue #1202: [questions] Recommended way to delete huge number of documents.

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

style95 opened a new issue #1202: [questions] Recommended way to delete huge number of documents.
URL: https://github.com/apache/couchdb/issues/1202
 
 
   What is the most desirable way to delete a huge number of documents?
   
   For example, let's say I want to delete 500K ~ 1000K documents.
   Since there are too many documents, I cannot query/delete them using one request.(request is timed out.)
   So what I am trying is, first query the number of documents, and send bulk deletion request multiple times with `limit` parameter.
   
   e.g) If counts are 500K, then calculate the required number of requests, first.
   
   ```
   500k / 2000(limit value) = 250   // So I need to send 250 requests to delete documents.
   ```
   
   But with this approach, my `count` query also hung and timed out.
   (If `_count` reduce function has never been called)
   
   So what is the recommended way to delete huge number of documents?
   
   

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