Formula, one field complex or multiple table field simple
 

Please comment on whether it is best, (execution speed wise), to reach a complex result built by having a complex formula broken down into simpler sequential multiple simple formula fields with each field using the value of a previous field in its calculation and then the final field containing the complex result OR if whether it is best to use one field with a very complex formula to reach the same result?

Formula, one field complex or multiple table field simple
 

on 2/12/2012, DbMstr supposed :
Please comment on whether it is best, (execution speed wise), to reach a
complex result built by having a complex formula broken down into simpler
sequential multiple simple formula fields with each field using the value of
a previous field in its calculation and then the final field containing the
complex result OR if whether it is best to use one field with a very complex
formula to reach the same result?

Breaking things down into smaller pieces so you can have individual
results for each piece will definitely require more processing. In this
context the answer is that it's better (performance-wise) NOT to invoke
extraneous processing whenever possible.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc