performance of calculation example (ABAP, Open SQL, CDS)

[Michael_Keller]

Dear community, I recently presented a calculation example with ABAP, Open SQL and ABAP CDS in this blog. It was about the different technologies that can be used to achieve the same result. I was surprised by the interest in the example. For the sake of completeness, I would now like to add a performance analysis. First, a few notes ...

The primary key of the database table ZCALC has been set to NUMC10 as data element. This allowed more test data. With a report, I generated 2,000,000 test records.

test records

I've adjusted the code of my example a little bit and implemented the respective solutions in methods.

REPORT zcalculation_example.



CLASS lcl_calculation_example DEFINITION.

  PUBLIC SECTION.

    METHODS abap_based.

    METHODS open_sql_based.

    METHODS cds_based.

ENDCLASS.



CLASS lcl_calculation_example IMPLEMENTATION.

  METHOD abap_based.

    TYPES: BEGIN OF calculation,

             example         TYPE numc10,

             summand_1       TYPE int4,

             summand_2       TYPE int4,

             addition_result TYPE int4,

           END OF calculation.



    TYPES calculations TYPE TABLE OF calculation WITH KEY example.



    DATA abap_based_result TYPE calculations.



    SELECT * FROM zcalc

             INTO CORRESPONDING FIELDS OF TABLE abap_based_result.



    LOOP AT abap_based_result ASSIGNING FIELD-SYMBOL(<row>).

      <row>-addition_result = <row>-summand_1 + <row>-summand_2.

    ENDLOOP.

  ENDMETHOD.



  METHOD open_sql_based.

    SELECT example,

           summand_1,

           summand_2,

           summand_1 + summand_2 AS addition_result

           FROM zcalc

           INTO TABLE @DATA(open_sql_based_result).

  ENDMETHOD.



  METHOD cds_based.

    SELECT * FROM zcdscalc

             INTO TABLE @DATA(cds_based_result).

  ENDMETHOD.

ENDCLASS.



START-OF-SELECTION.

  DATA(example) = NEW lcl_calculation_example( ).

  example->abap_based( ).

  example->open_sql_based( ).

  example->cds_based( ).

I carried out the runtime analysis with the transaction SAT. I focused on the runtime of operations related to internal tables and Open SQL statements. As system I used the "SAP NetWeaver Application Server for ABAP 7.52" (ASE) from the course "openSAP: Writing testable ABAP Code". The system runs via Amazon Web Services. I repeated the measurement several times. Here is the result of the last measurement.

profile trace results

hitlist

The first "DB: Fetch ZCALC" relates to the code in method OPEN_SQL_BASED. The second "DB: Fetch ZCALC" and "Loop At IT_13" relate to the code in method ABAP_BASED.

database tables

database table times on ZCALC

My question to the community: Have I done the runtime measurement correctly and is this understandable? What do you think? Any comments?

 

Best regards, thanks for reading and please stay healthy

Michael

 

P.S.: Please support the virtual wishing well.

P.S.S.: Not tired of reading blogs? Check this blog by johannes_gerbershagen11. I really recommend it.