performance of calculated fields
Posted: Tue 26 Jun 2007 12:52
Hi, I'm just trying to make some performace optimizations of my project using a profiler and I found, that the critical point is the oncalcfields-event - there are 4 simple assignments to calculated fields. Really just "myfield.asfloat := variable".
The OnCalcFields event is executed approx. 500 times and the profiler says, it takes 0,5 sec!
I think, this is really too much: one simple assignment to a calcfield takes > 0,25 millisecond (on a comp with AMD X2 and enough free memory)!
My query has pretty much fields, slightly over 100.
Is some performance optimization in this area possible? Or, is there a way to make it faster - like placing the field first in the field list, or last, or anything else?
Thanks for your help.
Ludek.
The OnCalcFields event is executed approx. 500 times and the profiler says, it takes 0,5 sec!
I think, this is really too much: one simple assignment to a calcfield takes > 0,25 millisecond (on a comp with AMD X2 and enough free memory)!
My query has pretty much fields, slightly over 100.
Is some performance optimization in this area possible? Or, is there a way to make it faster - like placing the field first in the field list, or last, or anything else?
Thanks for your help.
Ludek.