topic Performance tuning in Application Development and Automation Discussions

Performance tuning

Former Member — Sun, 27 Mar 2005 04:18:11 GMT

Hey guys,

I have two things to confirm regarding performance in abap program.

1-Comparision of Loop..Endloop stmt in SELECT query and

Selectoption parameter IN option in SELECT query.

(which process is more fast in performance.)

2-Could you pls confirm whether Code-2 is more faster than code-1 operation.?

if so can you pls tell will the result of both code-1 and 2 are same?

Here wk_monat is Month(duration) input.

Code-1.

WK_MONAT = '01'.

DO.

SELECT BELNR BUZEI BLART MWSKZ HKONT SHKZG DMBTR

INTO CORRESPONDING FIELDS OF TABLE ITAB_BSIS

FROM BSIS WHERE BUKRS = itab_t001-BUKRS AND

GJAHR = P_GJAHR AND MONAT = WK_MONAT AND

WK_MONAT = WK_MONAT + 1.

ENDDO.

COde-2

wk_monat is parameter.

SELECT BELNR BUZEI BLART MWSKZ HKONT SHKZG DMBTR

INTO CORRESPONDING FIELDS OF TABLE ITAB_BSIS

FROM BSIS WHERE BUKRS = itab_t001-BUKRS AND

GJAHR = P_GJAHR AND MONAT <= WK_MONAT AND

ambichan.

Re: Performance tuning

Former Member — Sun, 27 Mar 2005 04:51:09 GMT

Hi,

As you might be aware of the SAP system 3-tier architecture, the idea is to keep the roundtrips to the database as low as possible. When you issue a SELECT statement inside any sort of a loop (do, while, loop at), the R/3 has to issue a SELECT in every loop pass. This is not advisable. In case of selection options, the complete select-option table is first interpreted into an SQL query and then passed to the database in one go. Hence only a single trip to the database is required thus improving performance.

In code-1, you have issued the SELECT in a loop. Please avoid this. Keeping other checks aside, the SELECT statement in code-1 is not logically correct. Rather that writing


AND MONAT = WK_MONAT AND WK_MONAT = WK_MONAT + 1.

you should write


AND ( MONAT = WK_MONAT OR WK_MONAT = WK_MONAT + 1 )...

If you want to select a range of data, you might would like to give BETWEEN a try.

Regards

Message was edited by: Shehryar Khan