Hey Chuck, Not sure what “hash and stir” means?
Matching data requires one kind of index for speed and doing a radial search another. In the db where I only have 1/2 million records with longitude as a real the index returns a range quite quickly. So I’ll keep it for the radial search. For matching the data the jury is still out. Appreciate, John… > Sure you hash and stir that, when searching for a particular lat/long > combination you has entry and search > > This will not help in distance calculations > > How about this for a create a concatenated key that has two parts for each > > Named LatKey > Lat_before decimal > Lat_after decimal > > LongKey > Long_before decimal > long_after decimal > > do queries > and process using fields that contain the entire lat and long as a real > > Regards > > Chuck ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************