locked
Dynamics web interfaces (query speed) RRS feed

  • Question

  • Hi,

    Running the same query against CRM 2011 it seems to me that...

    • LINQ is slow (dog slow in fact)
    • FetchXML is slightly quicker (but only a little)
    • The REST interfaces are the fastest (by far)

    Is that what you'd generally expect to see?

    J.K.

    Thursday, September 4, 2014 11:05 PM

All replies

  • As far as your options with querying data in CRM, you may want to check out this Dynamics Premier Field Engineering blog that discusses limitations by API, this will help you choose which option to use. If you have a choice between two API's, my general rule of thumb is to use FetchXml as it is a little faster than the other methods in returning data, although using FetchXml has its limitations as far as query options too.

    This is not a simple question however, because all of these tactics rely on several factors such as:

    1. Retrieving only those records needed
    2. Retrieving only those fields needed
    3. Is metadata needed?
    4. What will the retrieved data be used for?

    ...hope this helps


    I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful. Michael Mayo

    Sunday, September 14, 2014 7:11 PM