Forum Discussion
Bulk updating performance
Hi, I am currently working on a migration project from SQL server to SharePoint Lists and SharePoint document libraries. The SQL server store around 1.29 million (1.2 TB) files as filestream obje...
That's because you're being throttled. Check this to mitigate this:
https://learn.microsoft.com/en-us/sharepoint/dev/general-development/how-to-avoid-getting-throttled-or-blocked-in-sharepoint-online
Also make use of Graph API to preform this task
https://learn.microsoft.com/en-us/sharepoint/dev/general-development/how-to-avoid-getting-throttled-or-blocked-in-sharepoint-online
Also make use of Graph API to preform this task
I switched execute_query() to execute_query_with_incremental_retry() but that doesn't seem to have improved performance. I noticed that the python library also has an execute_batch function. But I have not been able to figure out the structure of the list or dict that needs to be the input to the load function preceding the call to execute_batch().