John, You have geodesic functions in Math4D, component available here : https://forums.4d.com/Post/EN/31847250/1/31847251#31847251
HTH Cordialement, Bernard Escaich > Le 10 avr. 2020 à 02:03, John J Foster via 4D_Tech <[email protected]> a > écrit : > > Hi All, > > I have a GEO database of almost 5 million cities. They include various data > and latitude and longitude. > > I need to use the Longitude file in searches. To speed it up I need to index. > Many of the values are similar like 141.235 or 141 3.23 and so on. So for > those who might know would a Cluster index be better suited or a B-Tree? > > Thanks, > John… > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

