Skip to Content
0
Former Member
May 29, 2007 at 09:20 AM

Modifying Query program

16 Views

Hi All,

When I modifed the query genarated program(copied to SE38), by adding additional 2 fields.. the performance of the program became very bad..

the actual program is taking 44 seconds.. where as modified program is taking

1600 seconds..

when I tried to find the problem, the data selection(select stmts) is very fast.. but the read statements inside the loop taking very much time eventhough I used binary search or hashed key internal table.. even the display statements also taking very long time..(The records it is printing is 40k).. so in debugging I am not finding any difference..

Is there any solution for this.. what might be the actuall problem

Please help me..

Thanks in advance..