On the page in Microsoft docs where they discuss API Service Protections there is towards the end of the page a part which gives some recommendations.
Some are great, like the recommendation to use many threads and remove the affinity cookie, however when I read it I really bounced at the recommendation that batching shouldn’t be used. That just didn’t rime with my experiences of doing heavy dataloads to Dataverse. So I thought I might just test to see if it was true or not by creating a simple script in SSIS with Kingswaysoft. My results, using batching compared to not using it gives more than a 10x performance increase.
Gustaf Westerlund, CIO and founder of CRM-Konsulterna