Bug
When a feature class has a shape field size above and below 10kb, array fetching is used for the first 100 features and row by row is used for the rest.
| Bug ID Number | BUG-000119498 |
|---|---|
| Submitted | January 18, 2019 |
| Last Modified | June 5, 2024 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.6 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Known Limit |
Additional Information
Beginning with 10.4.x, ArcGIS began using read committed snapshot isolation when working with databases in SQL Server. This moved forced the adoption of keyset cursors, and while array fetching definitely helps improve performance for fetching data from the keyset cursor, the size of the data fetched becomes important. The decision was made to allow shapes that were less than 10 KB to be fetched with array fetching, and larger are fetched row by row.Workaround
Dice operation using a vertex limit of 425 (above which is 10kb), results in a shape size of 9kb for all features 10kb and up, therefore improving performance through array fetching.
Steps to Reproduce
Bug ID: BUG-000119498
Software:
- ArcSDE/Enterprise Geodatabase
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