Bug
Map export requests querying branch versioned data are 2.5 times slower in SAP HANA compared to SQL Server.
| Bug ID Number | BUG-000177709 |
|---|---|
| Submitted | July 7, 2025 |
| Last Modified | December 31, 2025 |
| Applies to | ArcGIS GIS Server |
| Version found | 11.1 |
| Operating System | Windows Server |
| Operating System Version | 2022 |
| Status | As Designed |
Additional Information
The root cause of this performance issue is GCS spatial reference related. Spatial operation in true GCS spatial reference requires calculation in 3D and is thus by nature slower than planar calculation. The user data was migrated from the SQL Server geometry type using GCS spatial reference. The SQL Server geometry type handles GCS data in a planar manner. SAP HANA geometry supports true GCS. When such data is migrated from SQL Server to SAP HANA, the GCS data exhibits true GCS behavior. This causes the performance change. Such data can be migrated to SAP HANA using the matching planar version of the GCS spatial reference for better performance. It is recommended that EQL migrate the data from SQL Server to the SAP HANA planar version of the matching GCS.Steps to Reproduce
Bug ID: BUG-000177709
Software:
- ArcGIS GIS Server
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