> Le 13 avr. 2020 à 19:36, Bernard Escaich via 4D_Tech <[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] **********************************************************************
