“Combining records in order to reduce number of records in a feature class”

566
7
Jump to solution
11-05-2017 03:50 AM
AlaaFlaifel
Occasional Contributor

“Combining records in order to reduce number of records in a feature class”

We’ve a feature class that contains walls (line features). Each wall consists from multiple number of lines which leads to have around 800000 records. This high number of records causes a significant delay in performance. We’re trying to reduce the number of features by combining records together. How we can achieve this in the least time possible.

Thanks,

Alaa

0 Kudos
1 Solution

Accepted Solutions
7 Replies
DanPatterson_Retired
MVP Emeritus
AlaaFlaifel
Occasional Contributor

Thanks Dan, Dissolve worked great with us and the performance improved Significantly. I was able to reduce the number of records to only 79.

JoshuaBixby
MVP Esteemed Contributor

What kinds of performance problems are you having?  Drawing slowness?  Drawing slowness can be just as much, if not more, impacted by vertex density as it can by the total number of records.  The screenshot you show doesn't appear to have that many records in it, if it draws slow at that scale, I would look into whether reducing vertices is an option:  About simplifying and smoothing a feature—Help | ArcGIS Desktop 

AlaaFlaifel
Occasional Contributor

Thanks all for your suggestions.

Actually its very slow when trying to transfer the data (using copy ) and also when displaying the features. 

0 Kudos
DanPatterson_Retired
MVP Emeritus

Given the size of the file, it may be your computer.  Have you tried to improve the settings using available options?

http://desktop.arcgis.com/en/arcmap/latest/map/working-with-arcmap/setting-arcmap-options.htm

And have you tried to dissolve to see if it improves the load time?

AlaaFlaifel
Occasional Contributor

It was taking a very long time to copy the data from mdf to gdb. However, after using dissolve, the issue was resolved and it copies fast now.

0 Kudos
DanPatterson_Retired
MVP Emeritus

glad it worked out!