harrybowman

Any suggestions to speed up Record deletion? 13 million, will take 12 HOURS

Discussion created by harrybowman on May 18, 2012
Latest reply on May 22, 2012 by harrybowman
Totally unacceptable non-performance
21 million records in file geodatabase table
Selecting by a single attribute ADDRESS_TYPE = 'A' via Make Feature Layer. Deleting with Delete Features outside of edit session. Eerily, the Make Feature Layer takes seconds - did it fail?
The attribute has an attribute index built on it.
18% complete is 2.5 hours.

I manually selected the same records from the attribute table in a different copy of the data. Then ran Delete Features outside an edit session. Performance similarly slow.

What can be done?

Suggestions welcome. Simply cannot do my job with 10.0 without speed up. Previously such operations were not impossibly slow.

Outcomes