XrmLinq’s performance compares very favorably with other dynamics crm linq providers

XrmLinq’s commitment to performance and product quality was shown recently as the performance of XrmLinq v1.5.1 was evaluated against all available dynamics crm linq providers.

A simple query was executed 1000 times in batches of 100 and execution times were measured and compared with baseline CRM SDK data. XrmLinq’s scores show to advantage in QueryExpression testing and compare very favorably in FetchXml tests. XrmLinq has focused on improving these scores in our current new release v1.5.1.

XrmLinq’s aim is for execution times close to dynamics CRM SDK’s performance.

Who’s being tested?

With CRM SDK 4.0.9 results acting as the control group

• XrmLinq v1.5

The set-up

A virtual server running on hyper-v, Windows 2008 32bit with 4GB of ram and dynamics crm 4 enterprise with demo data loaded was used.

We used a simple query – filter all the contacts whose names start with ‘a’ and skip the first ten records then select the next ten and order the results by their fullname and return the fullname.

var results = (from c in ctx.Contacts

               where c.FullName.StartsWith("a")

               orderby c.FullName

               select c).Skip(10).Take(10).ToList();

We then executed this query 1000 times in batches of 100.

Results

Each run executed a total of 100 queries. The results show the average time in milliseconds taken to execute a single query.

QueryExpression

FetchXml

Comments

As you can see, the Dynamics CRM SDK is about 3-4 milliseconds faster than XrmLinq. XrmLinq has focused on optimizations for XrmLinq v1.5 to ensure the execution time is as close to that of Dynamics CRM SDK as possible.