I was wondering if there is a preference for performance using multiple SingleField Select eSQL calculation fields vs A Single Multi-Select Field eSQL multi-select + Multiple List() calculation Fields
My gut and limited understanding of filemaker made me believe that a single query + multiple native functions would have been less demanding than multiple queries of the same record record. It does not seem to be true... any confirmation or advice on best practices?
an example of the two formats are listed below. In practice I have about 6 calc fields at the moment
|Original||eSQL Select X where....||eSQL Select y..||eSQL Select Z..|
|New||eSQL Select X,Y,Z Where...||List (fieldA, 1)||List(fieldA,2)|