topic Re: Loop in normal ABAP vs AMDP in Application Development and Automation Discussions

Loop in normal ABAP vs AMDP

selva123 — Thu, 15 Oct 2020 13:58:27 GMT

I write simple SELECT on MARA table in AMDP and populate an internal table with MARA data. I loop MARA internal table outside the AMDP and write some logic inside the loop. I can loop MARA internal table in AMDP itself using the statement FOR and write the same logic. Which will give better performance?

Looping Internal table in AMDP using FOR

DECLARE lv_index "$ABAP.type( sy-index )";     
DECLARE lv_matnr "$ABAP.type( matnr )";     
lt_mara = SELECT * FROM mara LIMIT 100;     
for lv_index in 1..record_count( :lt_mara ) do         
lv_matnr = :lt_mara.matnr[ lv_index ];         
-- Write all required logic      
END FOR ;

Re: Loop in normal ABAP vs AMDP

Sandra_Rossi — Thu, 15 Oct 2020 14:44:23 GMT

Loop to do what?

Re: Loop in normal ABAP vs AMDP

matt — Thu, 15 Oct 2020 16:29:56 GMT

sandra.rossi A bim bam boom.

Re: Loop in normal ABAP vs AMDP

Sandra_Rossi — Thu, 15 Oct 2020 16:47:13 GMT

One possibility (SQLScript of course):

    DECLARE pos INTEGER DEFAULT 0;
    DECLARE i INTEGER;
    FOR i IN 1..10 DO
        pos = :pos + 1;
    END FOR;

Re: Loop in normal ABAP vs AMDP

selva123 — Fri, 16 Oct 2020 06:09:34 GMT

Sorry. My question was not detailed. I have rewritten my question. Please provide your valuable comments.

Re: Loop in normal ABAP vs AMDP

Sandra_Rossi — Fri, 16 Oct 2020 06:51:34 GMT

So, what takes longer between

ABAP > DBI > network > DB execution > network > DBI > ABAP

and

ABAP > DBI > network > DB procedure > DB execution > DB procedure > network > DBI > ABAP

I guess the time depends on the volume of network traffic.

But is it significant compared to DB execution time?