How To: Increase performance displaying selected sets in ArcGIS sub-selected features from ArcSDE feature classes
Performance can degrade when very large selection sets are made from ArcSDE-based feature classes. It is possible to increase the performance by increasing the number of features cached on the client. The number of features cached on the client can be increased by creating a new Windows Registry DWORD value called 'SelectionThreshold'. This addition increases the number of selected records that can be cached in the local client memory rather than having ArcSDE write these records to the user's log file tables.
The instructions provided describe how to increase performance when displaying selected sets in ArcGIS sub-selected features from ArcSDE feature classes.
Warning: WARNING! This article contains instructions to make specific changes to essential parts of your operating system. If these changes are not done correctly, serious problems to the computer operating system and files may occur. First, Esri recommends that you make a complete backup of your system, including the registry, before implementing any of the specific changes. It is highly recommended that you consult with your IT/MIS department, or other qualified computer systems professional before proceeding. Esri cannot guarantee that you can solve problems that result from incorrect use of the Registry Editor utility. Use the Registry Editor utility at your own risk. Note: Your operating system and any subsequent service packs may effect these instructions.
These instructions are subject to change without notice.
From the Windows desktop, click Start > Run, type 'regedit' and click OK.
ArcGIS Desktop 9.3.x:
In the Registry Editor browse tree on the left, navigate to HKEY_CURRENT_USER > Software > ESRI.
ArcGIS Desktop 10.0:
In the Registry Editor browse tree on the left, navigate to HKEY_CURRENT_USER > Software > ESRI > Desktop10.0.
ArcGIS for Desktop 10.1:
In the Registry Editor browse tree on the left, navigate to HKEY_CURRENT_USER > Software > ESRI > Desktop10.1.
• If the Geodatabase key does not exist under this folder, right-click it, select New > Key and name it 'Geodatabase'.
• If the Geodatabase key already exists, continue to Step 4.
• If the Settings key does not exist under Geodatabase, right-click Geodatabase, select New > Key and name it 'Settings'.
• If the key already exists, continue to Step 5.
• If the DWORD value SelectionThreshold does not exist under Settings, right-click Settings, select New > DWORD Value and name it 'SelectionThreshold'.
• If the key already exists, continue to Step 6.
Right-click SelectionThreshold and select Modify.
In the Edit DWORD Value window, select Decimal as the Base and enter a reasonable number, such as 5000, in the Value data box. Click OK.