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?
Hello Denny,
Well, most of the references regarding your questions might be quite irrelevant. Mostly, people don’t realize that their c#/PS aren’t that efficient, continue copy-pasting quite doubtful code over and over from internet to production.
I would recommend to take a look on batching operation with SharePoint. The following post provides more context –Â Deleting all the items from a large list in SharePoint. The general idea is to utilise SPWeb.ProcessBatchData which consumes specific XML string to get some operation done. So that you might create an XML string with ListItem IDs to be deleted and it would work well.
The key point now is to understand how you may grab all the IDs to be deleted. You may consider ContentIterator class (also, take a look how it works within Reflector) to get safe iterations all over the big list.
That’s the basic ideas which might help to to get the right point in your solution.
Cheers.