Dynamics CRM Execute Multiple – Performance Tests

Roshan Mehta, 09 January 2013

In my last post, I wrote about the new ExecuteMultipleRequest available in the December 2012 release of Microsoft Dynamics CRM 2011. I can conclude that this new method is fast, but how much faster is it than running single transactions at a time? To answer this question, we will conduct some tests to create, update, and delete 10,000 contacts using these methods.

I have created a simple console application which will fire multiple transactions to the Dynamics CRM 2011 platform. 10,000 records will first be created, followed by a retrieve, update, and finally a delete. The application is connected to an on-premise deployment of Dynamics CRM 2011.

Firstly, let’s look at the traditional approach of processing single transactions at a time. The entire process completed in 1310 seconds.

Next we’ll compare the new ExecuteMultipleRequest method which will push batches of 1000 transactions to the CRM platform. The entire process completed in 1040 seconds, over four minutes faster than the traditional approach!

As you can see from the results above, the ExecuteMultipleRequest will improve the total processing time for your custom CRM integrations.