topic Python Optimization Techniques in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/python-optimization-techniques/m-p/114487#M3913 <HTML><HEAD></HEAD><BODY><SPAN>Hi Forum Folk,</SPAN><BR /><BR /><SPAN>I am writing to ask for suggestions for speeding up my script.</SPAN><BR /><BR /><SPAN>I currently have a 2 tables in a File Geodatabase.&nbsp; The first [TABLE1] has approximately 2000 records and the second [TABLE2] approximately 200000 records. [TABLE2] contains a foreign key from [TABLE1]</SPAN><BR /><BR /><SPAN>I am currently using a SearchCursor with a Where statement to retrieve the relevant records from [TABLE2] for each row of [TABLE1].&nbsp; Even though it has been suggested by ESRI to perform this process, it is taking approximately 1-2 seconds for the SearchCursor to execute and return its result set.&nbsp; Each result set consists of between 100-2000 records.</SPAN><BR /><BR /><SPAN>The execution time seems incredibly slow for this operation.&nbsp; I feel I may be missing a tweak that would speed this up, is the SearchCursor performing any license checks or validation checks in the background each time it is executed?&nbsp; I have written some code to load [TABLE2] into a python dictionary to perform the look up on the foreign key.&nbsp; There was a marked speed up.</SPAN><BR /><BR /><SPAN>Your thoughts?</SPAN></BODY></HTML> Fri, 19 Aug 2011 16:03:36 GMT AndrwSmith 2011-08-19T16:03:36Z Python Optimization Techniques https://community.esri.com/t5/geoprocessing-questions/python-optimization-techniques/m-p/114487#M3913 <HTML><HEAD></HEAD><BODY><SPAN>Hi Forum Folk,</SPAN><BR /><BR /><SPAN>I am writing to ask for suggestions for speeding up my script.</SPAN><BR /><BR /><SPAN>I currently have a 2 tables in a File Geodatabase.&nbsp; The first [TABLE1] has approximately 2000 records and the second [TABLE2] approximately 200000 records. [TABLE2] contains a foreign key from [TABLE1]</SPAN><BR /><BR /><SPAN>I am currently using a SearchCursor with a Where statement to retrieve the relevant records from [TABLE2] for each row of [TABLE1].&nbsp; Even though it has been suggested by ESRI to perform this process, it is taking approximately 1-2 seconds for the SearchCursor to execute and return its result set.&nbsp; Each result set consists of between 100-2000 records.</SPAN><BR /><BR /><SPAN>The execution time seems incredibly slow for this operation.&nbsp; I feel I may be missing a tweak that would speed this up, is the SearchCursor performing any license checks or validation checks in the background each time it is executed?&nbsp; I have written some code to load [TABLE2] into a python dictionary to perform the look up on the foreign key.&nbsp; There was a marked speed up.</SPAN><BR /><BR /><SPAN>Your thoughts?</SPAN></BODY></HTML> Fri, 19 Aug 2011 16:03:36 GMT https://community.esri.com/t5/geoprocessing-questions/python-optimization-techniques/m-p/114487#M3913 AndrwSmith 2011-08-19T16:03:36Z