topic Re: Search Cursor vs Selection in Python Questions https://community.esri.com/t5/python-questions/search-cursor-vs-selection/m-p/277697#M21437 <HTML><HEAD></HEAD><BODY><P>Try it and time it....</P></BODY></HTML> Mon, 23 Sep 2019 14:02:45 GMT JoeBorgione 2019-09-23T14:02:45Z Search Cursor vs Selection https://community.esri.com/t5/python-questions/search-cursor-vs-selection/m-p/277695#M21435 <HTML><HEAD></HEAD><BODY><P>Has anybody tested if one is faster than the other? Say you have 300,000 records to go through and you want to find all the records that have nulls in a field, would selecting with a "IS NULL" where clause be faster than a search cursor running through? Or would the difference be negligible?&nbsp;</P></BODY></HTML> Mon, 23 Sep 2019 13:18:42 GMT https://community.esri.com/t5/python-questions/search-cursor-vs-selection/m-p/277695#M21435 MKF62 2019-09-23T13:18:42Z Re: Search Cursor vs Selection https://community.esri.com/t5/python-questions/search-cursor-vs-selection/m-p/277696#M21436 <HTML><HEAD></HEAD><BODY><P>Select Layer By Attribute will be, or should be, significantly faster since it is both compiled code as well as it pushes the execution to the data store tier closer to the data itself.&nbsp; That said, for 300,000 records I am not sure it makes a big difference either way.&nbsp; </P></BODY></HTML> Mon, 23 Sep 2019 13:52:54 GMT https://community.esri.com/t5/python-questions/search-cursor-vs-selection/m-p/277696#M21436 JoshuaBixby 2019-09-23T13:52:54Z Re: Search Cursor vs Selection https://community.esri.com/t5/python-questions/search-cursor-vs-selection/m-p/277697#M21437 <HTML><HEAD></HEAD><BODY><P>Try it and time it....</P></BODY></HTML> Mon, 23 Sep 2019 14:02:45 GMT https://community.esri.com/t5/python-questions/search-cursor-vs-selection/m-p/277697#M21437 JoeBorgione 2019-09-23T14:02:45Z