Search Cursor in Python

ModernGIS

I have a Python script that starts with a Search Cursor that goes through a File Geodatabase and looks for a unique number and produces a graph and prints it out to a .PDF. The Script works out just fine. BUT - each time I run it - it seems to take longer and longer. The first few times - it produces about 4 .PDFs each minute. Now - when I run it - it goes slower and slower - about 1 .PDF every 2 minutes.

Does the Search Cursor produce "Temp" files somewhere that needs to be cleared out? How can I speed this up?

ModernGIS

Chris-

Thank you for the past (2) posts. I will look at both ideas and see what I can come up with. Guess I should have said I am working on ArcMap 10.2

Also, instead of creating a list of each "TWACs_NUMBER", and running a seperate cursor for each one, just run a single cursor and store the lists in a dictionary, where each twacNo is a key and each key points to a list of meterNos. In v10.1 this would look like:

twacDict = {}
searchRows = arcpy.da.SearchCursor(table, ["TWACs_NUMBER","METER_NUMBER"])
for searchRow in searchRows:
   twacNo, meterNo = searchRow
   if twacNo in twacDict:
      twacDict[twacNo].append(meterNo)
   else:
      twacDict[twacNo] = [meterNo]
del searchRow, searchRows

twackList = twacDict.keys()
twackList.sort()
for twacNo in twackList:
   meterList = twacDict[twacNo]
   #make a graph here, since you now have a hook to the twacNo and it's list of meterNos