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?
The downside is that I have to do this on the server side with code rather than using CSOM or PS which was my preference. I work in an environment where deploying server side SP code is restrictive – and rightfully so. Do you know of a way to engage the batch processing from CSOM or PS?