Dataverse: Get best Threads and Rows Count

Optimizing data transfer to Dataverse involves considering multiple factors such as client hardware, network specifications, and individual table attributes, which can be complex, especially due to the Dataverse API limit that may lead to request rejections. While Microsoft's guidance exists, putting it into practice can be challenging. The article outlines a method using a C# program that gradually increases row numbers and processing threads to assess performance improvements. This program uses ExecuteMultipleRequest to prevent rejections, monitoring progress by allowing for customized adjustment limits and capturing data on optimal row and thread settings. Benchmarking iterations track errors, rows processed per second, and best achieved settings, adapting approach based on prior iteration results to maximize efficiency.

Article 3w Temmy Wahyu Raharjo

---

Login now to access my digest by 365.Training

Login