harrybowman

ADD_TO_SELECTION makes Select By Location slow- even if no more records will be added

Discussion created by harrybowman on Feb 27, 2013
Latest reply on Mar 4, 2013 by kimo
Data:

40 million lines in a file geodatabase
1 point in a shapefile

1. Select the point
2. Select by location on the lines, "within a distance" of 100 meters of the selected point

- takes basically 0 seconds - returns immediately with 2 line features selected. Good

3. *do the same selection* on the lines, "within a distance" of 100 meters of the selected, point, ADD_TO_SELECTION

- takes 4 minutes

Why? The time should be very small: the time for the selection (<1 second) plus whatever time it takes to add it to the list of already selected features.

Outcomes