I’m trying to delete roughly 50 million documents using N1QL. I’ll be doing that in multiple queries with batching. I tested with batch size of 10k and it finished in about 5 hours.
My question is if we delete so many documents with such queries in a short duration, how would it affect Couchbase’s re-indexing? Would it make Couchbase slow? If yes, what can I do to avoid that?
Thanks in advance!
PS: To summarize: will firing so many deletes in quick succession lead to any performance issue in Couchbase? Will it get slow to respond to other queries?
Our website uses Couchbase heavily and these deletes will be performed with our site up - so I’m worried if we will see any performance hit in Couchbase.