topic Re: Performance issue while using Select Query in Application Development and Automation Discussions

Performance issue while using Select Query

Former Member — Tue, 07 Oct 2014 16:17:00 GMT

Data:LT_GLT0 TYPE SORTED TABLE OF GLT0 WITH NON-UNIQUE KEY BUKRS RACCT,

SELECT * FROM SKB1

    INTO TABLE LT_SKB1

    WHERE BUKRS IN BUKRS AND

          SAKNR IN SAKNR AND

          WAERS IN WAERU AND

          FDLEV IN FDLEV

    ORDER BY BUKRS.

The below table is taking very long time and could you please any one can give any suggestions on this.

SELECT * FROM GLT0

      INTO TABLE LT_GLT0

      FOR ALL ENTRIES IN LT_SKB1_TMP

      WHERE RLDNR = '00'       AND

             RRCTY = '0'        AND

             RVERS = '001'      AND

             BUKRS = LT_SKB1_TMP-BUKRS AND

             RYEAR = LV_GJAHR   AND

        "    racct = lt_skb1-saknr AND

             RBUSA = SPACE      AND

             RPMAX = '16'.

As per my analysis that

1.Instead of using SELECT * FROM GLT0 and I will be specify the column names which are required.

2.I will be remove the FOR ALL ENTRIES and will be using INNER JOIN.

Any other suggestions which can help the performance?

it is taking very huge time to execute the Query

Re: Performance issue while using Select Query

former_member183804 — Tue, 07 Oct 2014 17:12:58 GMT

Hello Vemula,

the SELECT for all entries may issue a full table retrieval in case the internal table is empty. If the snippet captures all relevant code the first query might be intended to populate the internal table. There is however no check of sy-subrc and/or sy-dbcnt after the first query. Maybe adding such an check already solves some of the performance issues you experience currently.

On releated track the Code Inspector (TA SCI) and the ABAP Test Cockpit contains a check "Unsecure use of FOR ALL ENTRIES" that can be used for code scans in order to avoid such a flaw.

Best Regards

Klaus

Re: Performance issue while using Select Query

Former Member — Tue, 07 Oct 2014 17:21:20 GMT

Hi,

if LT_SKB1_TMP[] is not initial.

     SELECT * FROM GLT0

      INTO TABLE LT_GLT0

      FOR ALL ENTRIES IN LT_SKB1_TMP

      WHERE RLDNR = '00'       AND

             RRCTY = '0'        AND
             RVERS = '001'      AND

             BUKRS = LT_SKB1_TMP-BUKRS AND

             RYEAR = LV_GJAHR   AND

        "    racct = lt_skb1-saknr AND

             RBUSA = SPACE      AND

             RPMAX = '16'.

endif.

Re: Performance issue while using Select Query

Former Member — Tue, 07 Oct 2014 18:56:17 GMT

Hello,

Check if you can use the view ENT2006 instead of the table . That should improve performace significantly.

Thanks,

Sushma

Re: Performance issue while using Select Query

former_member404244 — Tue, 07 Oct 2014 19:38:56 GMT

Hello,

Yes you can go for inner join and also you can check if you can create a secondary index.

I hope you are checking the initiality of the master table before going for 'FOR ALL ENTRIES'.

Regards,

Nagaraj

Re: Performance issue while using Select Query

Former Member — Tue, 07 Oct 2014 22:24:41 GMT

hi,

use fm FAGL_GET_GLT0

Re: Performance issue while using Select Query

Former Member — Wed, 08 Oct 2014 03:37:00 GMT

In your code you are extracting the entries from SKB1 into LT_SKB1 where as in Select from GLT0 you are using for all entries in LT_SKB1_TMP. Are you moving the contents across the table otherwise the TMP table will be empty and the entire records for GLT0 will be read which could be slowing the process.

Regards

Re: Performance issue while using Select Query

Former Member — Tue, 14 Oct 2014 13:45:30 GMT

Hi,

could you please let me know how to use the view ENT2006.

Thanks

Durga Prasanth

Re: Performance issue while using Select Query

Former Member — Tue, 14 Oct 2014 13:46:02 GMT

I had used the function module FAGL_GET_GLT0 and still we are getting the performance issue.