Skip to Content
Former Member
Mar 12, 2007 at 10:05 AM

Long Calculation within loops



I'm facing problems with a FI report. The batch job took approx 4hours for one variant and some variants can't even complete on time. For this case, out of the 4hrs, only 1 hour is due to SQL access.

I've traced the 3hr performance problem to a form which does calculation and sum of figures within loops.

What could be the problem... or what would be a good way to further investigate this?

So far I have only done performance tuning for programs due to inefficient SQL statements.

So, this is something new to me.