Slow performance when you pin views in Microsoft Dynamics CRM
This article helps you resolve the problem that occurs when you pin views in Microsoft Dynamics CRM Client for Microsoft Office Outlook.
Applies to: Microsoft Dynamics CRM 2011
Original KB number: 2741514
Symptoms
Microsoft Dynamics CRM Client for Microsoft Office Outlook may perform slowly when pinning views.
Cause
When a view is pinned the records in the view are pulled down to the local SQL CE database in the {orgid.sdf} and cached. When views are pinned, they are presented to a user in list view and not paged views. Each time a pinned view is accessed, it returns results from the local .sdf files.
This data is updated periodically as a background process. If a user has several pinned views or on machines that do not have many resources this can cause slow performance and load issues.
Resolution
In order to prevent pinned views from pulling down information to local SQL CE caches, a registry key can be set on the Microsoft Dynamics CRM 2011 Outlook clients. This can also help to reduce the overall network traffic sent from a Microsoft Dynamics CRM 2011 server to a Microsoft Dynamics CRM 2011 Outlook client machine.
When this value is set to 1, users still have the ability to pin the views; however, the query is sent to the CRM Server to retrieve the results instead of from the local cache.
Important
This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, see How to back up and restore the registry in Windows.
To fix this problem, follow these steps:
- Log on to the Microsoft Dynamics CRM 2011 Outlook client machines as a user who has installed the Microsoft Dynamics CRM 2011 Outlook client.
- Click Start, click Run, type regedit, and then click OK. Navigate to the registry key,
HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient
. On the Edit menu, point to New, and then click DWORD (32-bit) Value. - Type DisableMapiCaching, and then press ENTER.
- Right-click DisableMapiCaching, point to New, and then click DWORD Value.
- Right-click DisableMapiCaching, and then click Modify.
- In the Value data box, type 1, and then click OK.
- Exit Registry Editor.
More information
Update Rollup 6 or higher must be installed in order for the DisableMapiCaching registry key to work. For more information on Update Rollup 6, see KB Microsoft Dynamics CRM 2011 Update Rollup 6.
Note
This registry key is not valid after Update Rollup 14 has been applied. This will have to be updated using the OrgDbOrgSettings Tool.