English

Bug: Converting geodatabase data with domains to shapefile is slow when using the Feature Class To Feature Class (conversion) tool

Description

Performance of Feature Class To Feature Class (conversion) or Table To Table (conversion) tool is slow when exporting to shapefile or dBASE (.dbf) if the input is a geodatabase feature class or table with attribute domains.

Cause

When converting a geodatabase feature class or table with attribute domains to a shapefile or dBASE (.dbf) table, the domain codes and descriptions are included in the output. The descriptions are stored in new fields with "_DESC" appended to the field name. The process of exporting the domain descriptions to the output is very slow.

Workaround

If domain descriptions are not required in the shapefile or dBASE (.dbf) output, consider using the Copy Features (management) or Copy Rows (management) tools to convert the geodatabase data to a shapefile or dBASE (.dbf) table. These tools do not export the domain descriptions to new fields and the performance is much faster.

Note:
Performance of domain export is expected to be significantly improved in ArcGIS 10.0 Service Pack 5.

Related Information