laptop and a wrench

Bogue

Map export requests querying branch versioned data are 2.5 times slower in SAP HANA compared to SQL Server.

ArcGIS GIS Server
Numéro d’ID de bogue BUG-000177709
EnvoiJuly 7, 2025
Dernière modificationDecember 31, 2025
S’applique àArcGIS GIS Server
Version trouvée11.1
Système d’exploitationWindows Server
Version du système d’exploitation2022
StatutAs Designed

Informations supplémentaires

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.

Étapes pour reproduire

ID de bogue: BUG-000177709

Logiciel:

  • ArcGIS GIS Server

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement