overwriteOutput in ArcGIS 10.2.2

3962
2
01-28-2015 08:26 PM
RussellBird
New Contributor

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.

0 Kudos
2 Replies
AdamCaldwell
New Contributor

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.

0 Kudos
SachinKanaujia
Occasional Contributor III

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?

0 Kudos