topic Re: Delay within internal loops - nested loops in Application Development and Automation Discussions

Delay within internal loops - nested loops

Former Member — Thu, 29 Jun 2006 05:58:13 GMT

Hi all,

I have generated report using nested loops.if i give some 200 hits ,it generates the report within 90 seconds.but if the hit limit increases above 500,the loop becomes infinite.i have checked the datas as well as select Queries,everything is fine.why it happens.please help me if u know the solution.

thanks in advance,

raj

Re: Delay within internal loops - nested loops

Former Member — Thu, 29 Jun 2006 06:00:22 GMT

Hi,

1). Try to avoide nested loops.

2). Try using READ WITH BINARY SEARCH

3). Use a SORTED TABLE the access is fast

Post urt code to let u know where u can fine tune the program.

Cheers

Re: Delay within internal loops - nested loops

Former Member — Thu, 29 Jun 2006 06:03:25 GMT

There should be no reason why the program goes into an infinite loop pass with a larger number of records, unless there is some problem with one of the records it is trying to access.

It seems to me that one of the records in the 500 has some problem, and that is why the system behaves strangely in that case. You can do some trouble shooting, for eg, have the system download a file with the loop pass number, so that you know at which loop pass it went into an infinite loop, and analyze the same.

Hope this helps.

Sudha

Re: Delay within internal loops - nested loops

former_member480923 — Thu, 29 Jun 2006 06:05:19 GMT

There are couple of solutions to this

a) try defining a sarted internal table for the inside table with the keys that you define in the where clause of your inside loop.

b) You can try the below code

loop at itab1.
read table itab2 with key .......
l_tabix = sy-tabix.
loop at itab2 from l_tabix.
<check the validity condition>
endloop.

this could kill about 3/4 of the time before

Hope this Helps

Anirban

Re: Delay within internal loops - nested loops

Former Member — Thu, 29 Jun 2006 06:08:14 GMT

Hi sudha,

I tried first 200 records,then 200 records like this i have checked upto 1000 records.the system produes the results within short time.but when i have checked above 500 ,it creates infinite loop.but sometimes the report comes after an 1 hour for 500 records.

thanks

raj

Re: Delay within internal loops - nested loops

Former Member — Thu, 29 Jun 2006 06:14:03 GMT

Hi vijay & anirban,

I have implemented the solutins whatever u have given.i have cross verified with my colleagues also.but this situation behaves very strange.i ll post my code .just go through that code and let me know where ia have to fine tune

thanks

raj

Re: Delay within internal loops - nested loops

Former Member — Thu, 29 Jun 2006 07:20:26 GMT

Wheres ur code?

Re: Delay within internal loops - nested loops

Former Member — Thu, 29 Jun 2006 13:41:49 GMT

Check this <a href="/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops">blog.</a>Rob