The list is a “Drop Off Library” in a Record Center site collection. Â I’m in the development phase and need to be able to add and remove 100k records at a time. Â I added 112k records via the OfficialFileCore object, and they didn’t route b/c I didn’t set up drop off library to use the correct content type. Â So when I go to remove the records, I’m getting errors that crash the system. Â The only script I’ve found was located here:
http://wp.ahcheng.com/2012/09/04/splistitem-delete-best-practise-sharepoint-splist/
This is the only one that will run without crashing the system. Â The other methods I’ve found have tried to load the SPItemCollection each time and it seems to be causing major memory problems. Â Is there a good way that doesn’t require major coding to simply tell SharePoint to “Clear this list of all splistitems”? Â Please?
You can do this using CSOM asynchronous batch, the key to my post is splitting each request into smaller chunks of around 1000, and chaining the requests. This is were my suggestion differs. Thus the slightly different approach to the batching algorithm presented on that page.
