Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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:

    http://mscrmshop.blogspot.co.uk/2012/04/how-to-update-parent-record-when-child.html

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Henk

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

    Monday, December 9, 2013 1:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    HTH!

    Thanks!

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