AnsweredAssumed Answered

oracle geodatabase 10.1 extremely slow while deleting and uploading polygons

Question asked by weralio on Mar 8, 2017

I have to update polygons by county in a nationwide layer (average amount of polys is 1500 per county).

Update implies deleting a full county and uploading the new one.
I have a python script that does the trick but for aprox 60 counties it takes aprox 9 hours

 

Using geodatabase 10.1 with Oracle 11g - 

 

Pseudocode of the script is

 

//select all counties to delete
arcpy.MakeFeatureLayer_management
arcpy.SelectLayerByAttribute_management

arcpy.DeleteFeatures_management

arcpy.Compress_management

 

//Loop thru counties updloading them
Loop with:
   arcpy.Append_management

 

arcpy.Compress_management

is this something expected timewise or there's a database tuning I'm missing.. (or something else I can use from python)??

Outcomes