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] **********************************************************************
