Do plugins have a 5000 record count limit & 2 minute timeout limit? RRS feed

  • Question

  • I'm building a rollup query based on a link I found for a client. The client has over 10,000 opportunity records. Should I use this method here:


    I am concerned that developing the plugin this way will be limited by the 5000 page limit and or the 2 minute execution timeout. I am intending to have the plugin run asynchronously. Any help is appreciated.

    Sunday, December 8, 2013 12:04 PM

All replies

  • Hello,

    In case you will use paging - 5000 is not a limit.

    Regarding 2 minutes limits for Async Plugin - I have tested this for CRM 2011 and I have no issues with async plugins that are running more then 2 mins.

    Dynamics CRM MVP/ Technical Evangelist at <a href="http://www.slickdata.com"> SlickData LLC</a><br/> <a href="http://a33ik.blogspot.com">My blog</a>

    Sunday, December 8, 2013 3:41 PM
  • Hi,

    I will suggest you to go for custom workflow.

    You will not get any issues related to timeout.

    Monday, December 9, 2013 1:09 PM
  • Hi,

    The code example you are referring to uses an aggregate type Fetch XML query. This query returns one single row in the result set, so the 5,000 records per page limit does not apply here.

    In most cases SQL Server can execute an aggregate over several thousands of records in an eyeblink. If you do experience performance issues, you can consider creating custom table indexes.

    Hope this helps.


    If this post is an answer or helpful, please do not forget to vote!

    Monday, December 9, 2013 1:37 PM
  • Hi,

    if you want your plugin to run for more than 2 minute than go with workflow activity.

    You can retrieve more than 5000 using paging cookie.

    http://koren-tako.blogspot.in/2011/06/ms-crm-2011-online-retrieve-limit.html for queryexpression.

    http://msdn.microsoft.com/en-us/library/gg309717.aspx for fetchexpression.



    • Proposed as answer by Kalim Khan Saturday, December 14, 2013 6:04 AM
    Monday, December 9, 2013 1:40 PM