Fastest query to select dupes from two columns?
Posted: Thu Sep 29, 2005 6:41 pm
I have a database of over 100,000 records.
I want to flag dupes based on latitude and longitude.
I'm thinking of writing a script to loop through all records starting from the 1st; I would compare the latitude and longitude of the 1st record to every other record and do that for all records. This doesn't seem terribly efficient.
Is there a faster way to do this?
Perhaps sort by latitude AND longitude?
I want to flag dupes based on latitude and longitude.
I'm thinking of writing a script to loop through all records starting from the 1st; I would compare the latitude and longitude of the 1st record to every other record and do that for all records. This doesn't seem terribly efficient.
Is there a faster way to do this?
Perhaps sort by latitude AND longitude?