Bug
The pagination used in feature service layer queries leads to increased CPU usage and poor performance on the database when feature services reference branch versioned datasets in a registered enterprise geodatabase.
| Bug ID Number | BUG-000131280 |
|---|---|
| Submitted | June 1, 2020 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 2.5.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
The Database Manageent Systems (DBMS) is being worked on to make the queries as efficient as possible. There have been numerous performance improvements to both how ArcGIS Pro sends queries as well as backend enhancements to SQL query optimizations. Recommended steps in ArcGIS Pro: 1. Maps are configured to use the feature cache. Manually fill the feature cache if needed. 2. Scale-based visibility of layers; at a given view level, it will not display dozens of pages worth of data. 3. Subtype group layers where applicable. 4. In some cases, use the 'Only display these scales when zooming' option to reduce extra queries when panning or zooming. For more information on the feature cache: https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/manage-feature-cache.htm For more information on the 'Only display these scales when zooming' option: https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/map-scales-and-scale-properties.htm#ESRI_SECTION1_824BE5688B39490C8216050BE9A2C8B5 If these steps are being followed and issues continue to be experienced with the latest software please submit a new issue.Steps to Reproduce
Bug ID: BUG-000131280
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App