import arcpy, time shp = r"C:\Users\THINK\Desktop\python\Data\TOWNS.shp" #da SearchCursor sTime = time.clock() rows = arcpy.da.SearchCursor(shp, ["TOWN", "TOTAL_SQMI"]) for row in rows: town = row[0] area = row[1] print ("The area of %s is %s sq miles."%(town, area)) del row, rows eTime = time.clock() tDiff = eTime - sTime print "da SearchCursor uses %s seconds."%(tDiff) #SearchCursor sTime = time.clock() rows = arcpy.SearchCursor(shp) for row in rows: town = row.getValue("TOWN") area = row.getValue("TOTAL_SQMI") print ("The area of %s is %s sq miles."%(town, area)) del row, rows eTime = time.clock() tDiff = eTime - sTime print "SearchCursor uses %s seconds."%(tDiff)
Solved! Go to Solution.
if __name__ == '__main__': import timeit shp = r"D:\TEMP\test.shp" print(timeit.timeit('for row in rows:id = row[0]', number=10,#run loop 10x and return average setup='import arcpy; rows = arcpy.da.SearchCursor(r"%s", ["PNTID"])'%shp)) print(timeit.timeit('for row in rows:id = row.getValue("PNTID")', number=10, #run loop 10x and return average setup='import arcpy; rows = arcpy.SearchCursor(r"%s", "", "", "PNTID")'%shp))
if __name__ == '__main__': import timeit shp = r"D:\TEMP\test.shp" s=''' rows = arcpy.da.SearchCursor(r"%s", ["PNTID"]) for row in rows: print row[0]'''%shp a=timeit.timeit(s,number=10,setup='import arcpy') s=''' rows = arcpy.SearchCursor(r"%s") for row in rows: print row.getValue("PNTID")'''%shp b=timeit.timeit(s,number=10,setup='import arcpy') s=''' rows = arcpy.da.SearchCursor(r"%s", ["PNTID"]) for row in rows: id=row[0]'''%shp c=timeit.timeit(s,number=10,setup='import arcpy') s=''' rows = arcpy.SearchCursor(r"%s") for row in rows: id=row.getValue("PNTID")'''%shp d=timeit.timeit(s,number=10, setup='import arcpy') e=timeit.timeit('for row in rows:id = row[0]', number=10,#run loop 10x and return average setup='import arcpy; rows = arcpy.da.SearchCursor(r"%s", ["PNTID"])'%shp) f=timeit.timeit('for row in rows:id = row.getValue("PNTID")', number=10, #run loop 10x and return average setup='import arcpy; rows = arcpy.SearchCursor(r"%s")'%shp) g=timeit.timeit('for row in rows:id = row[0]', number=10,#run loop 10x and return average setup='import arcpy; rows = arcpy.da.SearchCursor(r"%s", ["PNTID"])'%shp) h=timeit.timeit('for row in rows:id = row.getValue("PNTID")', number=10, #run loop 10x and return average setup='import arcpy; rows = arcpy.SearchCursor(r"%s", "", "", "PNTID")'%shp) print '1. da.SearchCursor:',a print '2. arcpy.SearchCursor:',b print '3. da.SearchCursor:',c print '4. arcpy.SearchCursor:',d print '5. da.SearchCursor:',e print '6. arcpy.SearchCursor:',f print '7. da.SearchCursor:',g print '8. arcpy.SearchCursor:',h
if __name__ == '__main__': import timeit shp = r"D:\TEMP\test.shp" print(timeit.timeit('for row in rows:id = row[0]', number=10,#run loop 10x and return average setup='import arcpy; rows = arcpy.da.SearchCursor(r"%s", ["PNTID"])'%shp)) print(timeit.timeit('for row in rows:id = row.getValue("PNTID")', number=10, #run loop 10x and return average setup='import arcpy; rows = arcpy.SearchCursor(r"%s", "", "", "PNTID")'%shp))
if __name__ == '__main__': import timeit shp = r"D:\TEMP\test.shp" s=''' rows = arcpy.da.SearchCursor(r"%s", ["PNTID"]) for row in rows: print row[0]'''%shp a=timeit.timeit(s,number=10,setup='import arcpy') s=''' rows = arcpy.SearchCursor(r"%s") for row in rows: print row.getValue("PNTID")'''%shp b=timeit.timeit(s,number=10,setup='import arcpy') s=''' rows = arcpy.da.SearchCursor(r"%s", ["PNTID"]) for row in rows: id=row[0]'''%shp c=timeit.timeit(s,number=10,setup='import arcpy') s=''' rows = arcpy.SearchCursor(r"%s") for row in rows: id=row.getValue("PNTID")'''%shp d=timeit.timeit(s,number=10, setup='import arcpy') e=timeit.timeit('for row in rows:id = row[0]', number=10,#run loop 10x and return average setup='import arcpy; rows = arcpy.da.SearchCursor(r"%s", ["PNTID"])'%shp) f=timeit.timeit('for row in rows:id = row.getValue("PNTID")', number=10, #run loop 10x and return average setup='import arcpy; rows = arcpy.SearchCursor(r"%s")'%shp) g=timeit.timeit('for row in rows:id = row[0]', number=10,#run loop 10x and return average setup='import arcpy; rows = arcpy.da.SearchCursor(r"%s", ["PNTID"])'%shp) h=timeit.timeit('for row in rows:id = row.getValue("PNTID")', number=10, #run loop 10x and return average setup='import arcpy; rows = arcpy.SearchCursor(r"%s", "", "", "PNTID")'%shp) print '1. da.SearchCursor:',a print '2. arcpy.SearchCursor:',b print '3. da.SearchCursor:',c print '4. arcpy.SearchCursor:',d print '5. da.SearchCursor:',e print '6. arcpy.SearchCursor:',f print '7. da.SearchCursor:',g print '8. arcpy.SearchCursor:',h
if __name__ == '__main__': import timeit shp = r"D:\TEMP\test.shp" s='rows = arcpy.da.SearchCursor(r"%s", ["PNTID"])'%shp c=timeit.timeit(s,number=100,setup='import arcpy') s='rows = arcpy.SearchCursor(r"%s", "", "", "PNTID")'%shp d=timeit.timeit(s,number=100,setup='import arcpy') print '1. da.SearchCursor:',c print '2. arcpy.SearchCursor:',d 1. da.SearchCursor: 0.032812795193 2. arcpy.SearchCursor: 0.497164226788