Search Cursor vs Selection

648
2
Jump to solution
09-23-2019 06:18 AM
MKF62
by
Occasional Contributor III

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? 

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
JoshuaBixby
MVP Esteemed Contributor

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.  That said, for 300,000 records I am not sure it makes a big difference either way. 

View solution in original post

2 Replies
JoshuaBixby
MVP Esteemed Contributor

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.  That said, for 300,000 records I am not sure it makes a big difference either way. 

JoeBorgione
MVP Emeritus

Try it and time it....

That should just about do it....
0 Kudos