1

I want to delete all documents from my collection, so I tried using bulkDeleteSproc mentioned at How to delete all the documents in DocumentDB through c# code but it is giving me timeout error. I have updated it to remove call of tryQueryAndDelete() from tryDelete function, now it is working without timeout issue. But it seems that it deletes only 100 documents each time. This seems to be very slow.

I tried providing maxItemCount=1000 but still it is fetching only 100 records at a time. I have around 500MB data in collection (around 408k documents). I am using collection with 100000 RU/Sec.

Please let me know if anybody face this kind of timeout issue and how to speed up this sproc?

Mahesh Dounde
  • 91
  • 12
  • Couple of things to think about, your data is distributed in different partitions. SP deletes data only from one partition so your collection RU is not utilized to its full potential. Are you using the continuation token properly. Share your code. – Rafat Sarosh Oct 05 '17 at 23:46
  • @Mahesh have you find solution for this? – arpan desai Jan 09 '18 at 05:45

0 Answers0