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