> 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?
I'd try distinct values first, a cluster is supposed to be better when there's enough repeated values. And most probably I'd try… I didn't understand from "141.235 or 141 3.23": what is the field type? You may also consider using another field with "simplified value" from longitude, depending on what's expected from that search. Or, if the search is always combined with other fields than longitude, make some tests and analyse query plan/query path to see if that index is required. -- Arnaud de Montard ********************************************************************** 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] **********************************************************************
