topic DeleteFeatures deleting records 1 at a time SDE 9.3.1 SQL 2008 (new bug?) in Data Management Questions https://community.esri.com/t5/data-management-questions/deletefeatures-deleting-records-1-at-a-time-sde-9/m-p/350240#M20070 <HTML><HEAD></HEAD><BODY><SPAN>When I upgraded to SDE 9.2 on SQL 2000 the DeleteFeatures_management geoprocessing tool would immediately delete all records at one time in a feature class.&nbsp; So total time about 2 seconds.&nbsp; Now I find that on SDE 9.3.1 it's gone back to the pre 9.2 behavior of deleting 1 record at a time.&nbsp; What happened.&nbsp; I changed my python script from pointing to a 9.2 SDE database to my new 9.3.1 and it has gone from 2 seconds to several hours for the deletefeatures command on a 1 million plus row feature class.</SPAN><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row.feattype == "table":</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gp.Deleterows_management(targetLayer)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else:</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gp.DeleteFeatures_management(targetLayer)</SPAN></BODY></HTML> Wed, 27 Oct 2010 17:37:27 GMT RandyKreuziger 2010-10-27T17:37:27Z DeleteFeatures deleting records 1 at a time SDE 9.3.1 SQL 2008 (new bug?) https://community.esri.com/t5/data-management-questions/deletefeatures-deleting-records-1-at-a-time-sde-9/m-p/350240#M20070 <HTML><HEAD></HEAD><BODY><SPAN>When I upgraded to SDE 9.2 on SQL 2000 the DeleteFeatures_management geoprocessing tool would immediately delete all records at one time in a feature class.&nbsp; So total time about 2 seconds.&nbsp; Now I find that on SDE 9.3.1 it's gone back to the pre 9.2 behavior of deleting 1 record at a time.&nbsp; What happened.&nbsp; I changed my python script from pointing to a 9.2 SDE database to my new 9.3.1 and it has gone from 2 seconds to several hours for the deletefeatures command on a 1 million plus row feature class.</SPAN><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row.feattype == "table":</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gp.Deleterows_management(targetLayer)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else:</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gp.DeleteFeatures_management(targetLayer)</SPAN></BODY></HTML> Wed, 27 Oct 2010 17:37:27 GMT https://community.esri.com/t5/data-management-questions/deletefeatures-deleting-records-1-at-a-time-sde-9/m-p/350240#M20070 RandyKreuziger 2010-10-27T17:37:27Z