Hi Arnaud, I have split out the longitudes into a text and real component. I have formatted the longitudes as “000” and if west of GMT prefixed with “-“ and if east prefixed with “+“. I'll do something similar with latitudes and then try building some radial searches and see.
Since all string is text is there a still a way to tell 4D that a field and thus an index is a fixed size? Anyway we shall see if theory and implementation matches! Appreciate, John… > On Apr 14, 2020, at 12:00 PM, [email protected] wrote: > > From: Arnaud de Montard <[email protected] <mailto:[email protected]>> > Subject: Re: Longitude Index: B-Tree or Cluster > Date: April 14, 2020 at 2:23:26 AM PDT > To: 4D iNug Technical <[email protected] <mailto:[email protected]>> > > > >> Le 13 avr. 2020 à 19:36, Bernard Escaich via 4D_Tech <[email protected] >> <mailto:[email protected]>> a écrit : >> >> Hi John, >> >> From the top of my head, indexes on long are less efficient than on text >> values ; I have a doubt, perhaps only for updating. > > I'd think the opposite, an index based on a "fixed length" field is always > more efficient (search, update…) than one based on a "variable length" field. > > -- > 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] **********************************************************************
