laptop and a wrench

Bug

Slow performance when running the Append Parcel Fabric geoprocessing tool with SQL Server.

Last Published: March 28, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000086926
SubmittedApril 14, 2015
Last ModifiedJune 11, 2020
Applies toArcSDE/Enterprise Geodatabase
Version found10.2.2
Operating SystemWindows
Operating System Version7
StatusNon-Reproducible

Additional Information

At ArcGIS 10.5, feature classes you create in a geodatabase in SQL Server that use Geometry or Geography storage will store attributes such as pointIDs, multipatches, and parametric entities (such as true curves) directly in the business table. Prior to ArcGIS 10.5, this information was stored in a side table that joined with the business table, and the join could cause poor performance if the side table contained lots of geometry attributes. This decreased performance was often noticed while working with parcel fabric datasets, for example. Using a 10.5 client, you can run the Migrate Storage geoprocessing tool to migrate the geometry attributes into the business table and take advantage of performance improvements. ***Note that 10.3 and earlier clients cannot connect to feature classes that use this new type of storage.

Steps to Reproduce

Bug ID: BUG-000086926

Software:

  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback