> Le 13 avr. 2020 à 23:51, John J Foster via 4D_Tech <[email protected]> a > écrit : > > Hey Bernard, > > I would use text values if I didn’t think I needed to do range searches. It’s > not a “live” db so I can play and experiment to my hearts content.
Considering 5 million pairs of long/lat values is a lot, I'd first try to see if I can store values in a different field type than a real. Examples: - integer or longint : multiply by 10^x and remove decimals; depends on the number of digits you need to keep (example, Lat,Long=48.862725,2.28759 becomes 48862725,2287590) - uuid: no limit about the encoded number, but I don't know if performances are better than real -- 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] **********************************************************************
