overwriteOutput in ArcGIS 10.2.2

RussellBird — Thu, 29 Jan 2015 04:26:57 GMT

Hi All

I have noticed some differences in times when copying feature classes (using arcpy.CopyFeatures_management) into a 10.2.2 Enterprise GDB compared to our existing 9.3.1 Enterprise GDB.

On a nightly basis, we update numerous feature classes, using a suite of python scripts, by blowing away and recreating the feature classes in our 9.3.1 Enterprise GDB, hence overwriteOutput is set to True.

We are migrating our Enterprise GDB to 10.2.2. Our copying/updating tests have shown an extra time lag when the feature class already exists in the 10.2.2 Enterprise GDB, and no lag time when the feature class does not exist in the 10.2.2 Enterprise GDB. The time lag is approximately 50 to 60 seconds per feature class (if it already exists). It appears that arcpy 10.2.2 takes extra time to delete the destination, if it exists, when overwriteOutput is set to True. This is timing problem as we update a 100+ feature classes on a nightly basis, hence an increase in up to 100 minutes.

I have replicated this scenario in a model, with the same time lag.

Existing Enterprise GDB environment:

Oracle 10g

SDE 9.3.1

New Enterprise GDB environment:

Oracle 11i

SDE 10.2.2

Has anyone else experienced this problem?

Any assistance or advice would be greatly appreciated.

Re: overwriteOutput in ArcGIS 10.2.2

AdamCaldwell — Wed, 11 Mar 2015 02:54:03 GMT

We also have the same problem, although our underlying datbase is Oracle 11g.

It would be great to know if anyone has had similar issues and has been able to recitfy them.

Re: overwriteOutput in ArcGIS 10.2.2

SachinKanaujia — Wed, 11 Mar 2015 06:00:20 GMT

Can you try putting the layer in IO mode or else manually dropping all the indexes and see if that helps?

How much time does delete take?

topic Re: overwriteOutput in ArcGIS 10.2.2 in Python Questions

overwriteOutput in ArcGIS 10.2.2

Re: overwriteOutput in ArcGIS 10.2.2

Re: overwriteOutput in ArcGIS 10.2.2