Skip to Content
-1
Feb 09, 2017 at 04:19 PM

HANA 1.0 - Testing Selection speed

335 Views Last edit Feb 20, 2017 at 12:58 AM 4 rev

Hi all,

I'd like to ask you an opinion.

I'm struggling with a matter. HANA performance Vs ORACLE performance on a Test system environment.

HANA and ORACLE have same package (Ehp8) and same machine power.

Only difference is that :

- SAP on ORACLE has Application Server and DB on the same server;

- SAP on HANA has Application Server on a machine and DB HANA on one other.

Those two does comunicate on optical fibre. Here in Test we still don't have HD ssd.

Here attached an image with time performance of HANA Vs ORACLE.

What I'm asking you is why these time differences.

Behind those data there's this simple SELECT:

First session of 100 Records - with one time read:

SELECT * FROM mara INTO @DATA(ls_mara).
  SELECT SINGLE * FROM makt INTO @DATA(ls_maktx)
        WHERE matnr = @ls_mara-matnr AND
        spras = @sy-langu AND
        matnr LIKE 'F%'.
  l_count = l_count + 1.
  CHECK l_count GT 100.
  EXIT.
ENDSELECT.

Second session with 10 records read 10 times:

SELECT matnr FROM ekpo INTO TABLE @DATA(lt_mat) UP TO 10 ROWS
      WHERE matnr LIKE 'F%'.


READ TABLE lt_mat INDEX 1 ASSIGNING FIELD-SYMBOL(<s>).
LOOP AT lt_mat ASSIGNING <s>.

  PERFORM select_val.

ENDLOOP.

FORM select_val.

  CLEAR l_count.
  SELECT * FROM mara INTO @DATA(ls_mara).
    SELECT SINGLE * FROM makt INTO @DATA(ls_maktx)
          WHERE matnr = @ls_mara-matnr AND
          spras = @sy-langu AND
          matnr LIKE 'F%'.

    l_count = l_count + 1.
    CHECK l_count GT 9.
    EXIT.

  ENDSELECT.

ENDFORM.

How can be possible those kind of differences?

And How can be possible that same select, divided 10 times, jump time till 4 times more??

Total of first and second session should be quite the same.


Sorry for the "cime di rapa" code :)

Thanks in advance

Regards