AnsweredAssumed Answered

multi eSQL  calc fields vs Single SQL and List()

Question asked by disabled_brianb on Jun 9, 2017
Latest reply on Jun 14, 2017 by taylorsharpe

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

     

    

 

ex.

SetupcalcAcalcB
calcC
OriginaleSQL Select X where....eSQL Select y..eSQL Select Z..
NeweSQL Select X,Y,Z Where...List (fieldA, 1)List(fieldA,2)

Outcomes