Thursday, May 16, 2013

Retrieve more than 5000 records frm MS CRM 2011 SDK

while we use the SDK for ms crm 2011 for retrieving records from any entities, by default it will fetch max 5000 records.
hw if there are more than that?
ans is, it ll not get more than 5000, it will fetch the 1st 5000 records.
to fetch all records, we need to do some changes in the regedit on the server.(if you have multiple servers, please add to all the crm servers).

just create a DWORD value named "TurnOffFetchThrottling" and set value to "1" under HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM in registry key (run regedit to get it).

hope this will help.
it may have some performance impact, as it will be applicable for all the entities.


No comments:

Post a Comment