Fast way to delete row from table

[zhengniu1]

hi, all

I am trying to delete row from file geodatabase table using following code:

import arcpy
import math

arcpy.env.workspace = r'C:\TempArcGISCalculate\Scratch.gdb'
arcpy.env.overwriteOutput = True

intable="Section0011"

Statstbl="C:/TempArcGISCalculate/Scratch.gdb/S11FirstStats"
Query = '"FREQUENCY"=1'

records = arcpy.SearchCursor(Statstbl,Query)
singlelst = []
for record in records:
    singlelst.append(record.getValue('Trace')) # it adds data who has single point only

del records
del record


pts = arcpy.UpdateCursor(intable)

for pt in pts:
    for i in singlelst:
        if pt.Trace == int(i):
            print "Deleting:", pt.OBJECTID, pt.Trace
            pts.deleteRow(pt)

del pts, pt            

In the table "Section0011", I have 534975 rows. When the script runs, it only remove about 1000 rows in couple hours, but has not finished yet. Is there any fast way to run deleteRow? please help

Thanks lot

[MarcinGasior]

In last part of the script try:

for pt in pts:
        if pt.Trace in singlelst:

instead of:

for pt in pts:
    for i in singlelst:
        if pt.Trace == int(i):

I simulated similar script situation with this code change and for feature class with over 550 000 rows, ~13 000 rows were deleted in less than 4 minutes.

[MathewCoyle]

Yes, I would implement Marcin's change. Your original script is running through every feature you want to delete for every row in your dataset. Uneconomical to say the least.

[zhengniu1]

Marcin and Mathew, Thank you so much