topic Re: Performance issue in Application Development and Automation Discussions

Performance issue

vinod_vemuru2 — Wed, 12 Sep 2007 10:44:08 GMT

Hi All,

I ahve doubt regarding Where clause in LOOP.

Which one will give better performance.

1. LOOP AT i_tab INTO wa_tab WHERE ......conditions

..Processing.

ENDLOOP.

2. LOOP AT i_tab INTO wa_tab.

IF conditions

..Processing.

ENDIF.

ENDLOOP.

Is it depends on total number of records/no of records that satisfy where clause in any way?

Regards,

Vinod.

Re: Performance issue

Former Member — Wed, 12 Sep 2007 10:46:36 GMT

Hi,

LOOP AT i_tab INTO wa_tab WHERE ......conditions

..Processing.

ENDLOOP.

is the best way at any time.

it doesn't depend on the number of records.

rgds,

bharat.

Re: Performance issue

former_member404244 — Wed, 12 Sep 2007 10:46:50 GMT

Hi,

This will give better performance..

1. LOOP AT i_tab INTO wa_tab WHERE ......conditions

..Processing.

ENDLOOP.

Regards,

Nagaraj

Re: Performance issue

Former Member — Wed, 12 Sep 2007 10:47:02 GMT

the first option would be better,

at the begining of the loop only, all the not required rows are removed.

always prefer the 1st option for performance issue.

Regards,

Prasant

*reward if useful

Re: Performance issue

former_member196517 — Wed, 12 Sep 2007 10:49:10 GMT

Hi Vinod,

actually it depends on the indexing of the table, if indexing is well defined than first will be better else both are nearly same..

Regards

Anuj

Re: Performance issue

vinod_vemuru2 — Thu, 13 Sep 2007 05:46:16 GMT

Thanks u all