topic Re: Performance tuning in Application Development and Automation Discussions

Performance tuning

Former Member — Wed, 15 Aug 2007 17:13:33 GMT

I have a SELECT statement that is bogging down the performance of my report. Can this be converted into 2 READ's. Any ideas on how to improve the performance of this code. Thanks.

  SELECT SINGLE qals~prueflos qals~aufnr qals~selmatnr afpo~dauat afpo~dwerk
        FROM ( qals
        INNER JOIN afpo ON afpo~aufnr = qals~aufnr )
        INTO (qals-prueflos, qals-aufnr, qals-selmatnr, afpo-dauat, afpo~dwerk)
        WHERE qals~matnr    = collector-matnr
          AND qals~charg    = collector-charg
          AND qals~art      = c_manualinsp
          AND qals~herkunft = c_gr_prod.

Re: Performance tuning

Former Member — Wed, 15 Aug 2007 17:18:51 GMT

HI,

Write two select instead of this join..

select single prueflos aufnr selmatnr from qalis into wa_qals where matnr = collector-matnr

and charg = collector-charg

AND art = c_manualinsp

AND herkunft = c_gr_prod.

if sy-subrc eq 0.

select aufnr dauat dwerk from afpo where aufnr = wa_qals-aufnr...

if sy-subrc eq 0.

your logic

endif.

Thask

mahesh

Re: Performance tuning

Former Member — Wed, 15 Aug 2007 17:28:03 GMT

Isnt a JOIN always faster than 2 select statements ?

Re: Performance tuning

Former Member — Wed, 15 Aug 2007 17:29:50 GMT

Not always...I think it depends on wether your are using the complete key, index and amount of data....but not really sure -:P

Greetings,

Blag.

Re: Performance tuning

Former Member — Wed, 15 Aug 2007 17:58:28 GMT

Did you find Answer ?

QALS - Key field PRUEFLOS ,you are not using here

if not see the my comments

if you do not have key field(Where condition) when you use select single ,then do not use select single command.

instead of select single ,use select up to 1 row ,see the performance now.

if you need help on select up to 1 row then see the saphelp.

Thanks

Seshu