oracle geodatabase 10.1 extremely slow while deleting and uploading polygons

511
0
03-08-2017 07:16 AM
Highlighted
New Contributor III

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)??

Reply
0 Kudos
0 Replies