topic Re: performance ..which one is better in Application Development and Automation Discussions

performance ..which one is better

Former Member — Sat, 16 Sep 2006 00:36:46 GMT

SELECT * " bukrs lifnr gjahr belnr blart

FROM bsak

appending table gt_bsak

INTO CORRESPONDING FIELDS OF TABLE gt_bsak

WHERE cpudt in r_cpudt

AND blart in r_blart

AND bukrs in s_bukrs

AND belnr in s_belnr

AND gjahr in s_gjahr

In the above stmt which one gives bstter performance.Is it appending table gt_bsak or

INTO CORRESPONDING FIELDS OF TABLE gt_bsak

Re: performance ..which one is better

Former Member — Sat, 16 Sep 2006 00:40:27 GMT

Hi Sam,

Use only INTO TABLE.

SELECT * " bukrs lifnr gjahr belnr blart
FROM bsak
<b>INTO TABLE gt_bsak</b>
WHERE cpudt in r_cpudt
AND blart in r_blart
AND bukrs in s_bukrs
AND belnr in s_belnr
AND gjahr in s_gjahr

INTO TABLE is faster then using appending and into corresponding fields.

Cheers

Re: performance ..which one is better

Former Member — Sat, 16 Sep 2006 00:41:00 GMT

Hi Sam,

If you are using :

select *

then use into corresponding field of table but

if you are using :

select fld1 fld2 fld3

then appending table would be better provided your internal table has 3 fields (fld1,fld2,fld3) only.

Cheers,

Vikram

Pls reward for helpful replies!!

Re: performance ..which one is better

Former Member — Sat, 16 Sep 2006 03:10:25 GMT

It doesn't matter, because performance will be degraded because of the WHERE clause. See my answer to your other question. You have to take care of the big problems first. You'll find that the small ones may not matter.

Rob

Re: performance ..which one is better

anversha_s — Sat, 16 Sep 2006 04:33:36 GMT

hi sam,

I simulated ur code in my system.

the best performance is this.

data : begin of gt_bsak occurs 0,

bukrs like bsak-bukrs,

lifnr like bsak-lifnr,

belnr like bsak-belnr,

blart like bsak-blart,

end of gt_bsak.

SELECT bukrs lifnr gjahr belnr blart

FROM bsak

INTO table gt_bsak

WHERE cpudt in r_cpudt

AND blart in r_blart

AND bukrs in s_bukrs

AND belnr in s_belnr

AND gjahr in s_gjahr.

here the prfmance is optimum.

rgds

anver.

if hlped rwrd points

Re: performance ..which one is better

Former Member — Sat, 16 Sep 2006 05:45:01 GMT

hi Sam,

SELECT bukrs lifnr gjahr belnr blartFROM bsak

INTO TABLE gt_bsak

WHERE cpudt in r_cpudt

AND blart in r_blart

AND bukrs in s_bukrs

AND belnr in s_belnr

AND gjahr in s_gjahr.

avoid using * select only the fields that you require ... in this way you can improve the performance a bit ..

Regards,

Santosh

Re: performance ..which one is better

abdul_hakim — Sat, 16 Sep 2006 05:58:42 GMT

hi,

use the below code..

data: begin of wa,

bukrs like bsak-bukrs,

lifnr like bsak-gjahr,

belnr like bsak-belnr,

blart like bsak-blart,

end of wa,

itab like table of wa.

select bukrs

lifnr

belnr

blart

from bsak into table itab

where cpudt in r_cpudt

AND blart in r_blart

AND bukrs in s_bukrs

AND belnr in s_belnr

AND gjahr in s_gjahr.

Performance Tips:

1.INTO CORRESPONDING will cause performance problem if the no of records are very less as

the runtime required to compare the field names will take longtime.

2.APPENDING will cause performance problem so always use INTO TABLE.Use APPENDING only if

itz necessary/ no other options..

Cheers,

Abdul Hakim

Re: performance ..which one is better

Former Member — Sat, 16 Sep 2006 15:24:23 GMT

The most important problem here is that the select statement doesn't use an index. All of the other suggestions will help, but you still need to go to BSEG (and BKPF for BLART) to significantly improve performance.

Rob