topic oracle geodatabase 10.1 extremely slow while deleting and uploading polygons in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/oracle-geodatabase-10-1-extremely-slow-while/m-p/820440#M3720 <HTML><HEAD></HEAD><BODY><P>I have to update polygons by county in a nationwide layer (average amount of polys is 1500 per county).</P><P>Update implies deleting a full county and uploading the new one.<BR />I have a python script that does the trick but for aprox 60 counties it takes aprox 9 hours</P><P></P><P>Using geodatabase 10.1 with Oracle 11g -&nbsp;</P><P></P><P>Pseudocode of the script is</P><P></P><P>//select all counties to delete<BR />arcpy.MakeFeatureLayer_management<BR />arcpy.SelectLayerByAttribute_management</P><P>arcpy.DeleteFeatures_management</P><P>arcpy.Compress_management</P><P></P><P>//Loop thru counties updloading them<BR />Loop with:<BR />&nbsp;&nbsp;&nbsp;arcpy.Append_management</P><P></P><P><SPAN>arcpy.Compress_management<BR /><BR /></SPAN>is this something expected timewise or there's a database tuning I'm missing.. (or something else I can use from python)??</P></BODY></HTML> Wed, 08 Mar 2017 15:16:42 GMT WalterEralio 2017-03-08T15:16:42Z oracle geodatabase 10.1 extremely slow while deleting and uploading polygons https://community.esri.com/t5/geodatabase-questions/oracle-geodatabase-10-1-extremely-slow-while/m-p/820440#M3720 <HTML><HEAD></HEAD><BODY><P>I have to update polygons by county in a nationwide layer (average amount of polys is 1500 per county).</P><P>Update implies deleting a full county and uploading the new one.<BR />I have a python script that does the trick but for aprox 60 counties it takes aprox 9 hours</P><P></P><P>Using geodatabase 10.1 with Oracle 11g -&nbsp;</P><P></P><P>Pseudocode of the script is</P><P></P><P>//select all counties to delete<BR />arcpy.MakeFeatureLayer_management<BR />arcpy.SelectLayerByAttribute_management</P><P>arcpy.DeleteFeatures_management</P><P>arcpy.Compress_management</P><P></P><P>//Loop thru counties updloading them<BR />Loop with:<BR />&nbsp;&nbsp;&nbsp;arcpy.Append_management</P><P></P><P><SPAN>arcpy.Compress_management<BR /><BR /></SPAN>is this something expected timewise or there's a database tuning I'm missing.. (or something else I can use from python)??</P></BODY></HTML> Wed, 08 Mar 2017 15:16:42 GMT https://community.esri.com/t5/geodatabase-questions/oracle-geodatabase-10-1-extremely-slow-while/m-p/820440#M3720 WalterEralio 2017-03-08T15:16:42Z