Cluster is meant when there are many duplicates. To do queries I would make a duplicate field and use a string conversion or a long code version. and not a real. Reals in my opinion are the slowest when it comes to queries. Or manipulation
Sent from my iPhone > On Apr 12, 2020, at 6:57 PM, Bernard Escaich via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > 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 <4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** > > ********************************************************************** > 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 > ********************************************************************** ********************************************************************** 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 **********************************************************************