topic Performance Tuning in Application Development and Automation Discussions

Performance Tuning

Former Member — Tue, 21 Aug 2007 11:44:49 GMT

hi all,

Performance wise which is correct one.

1. select * from vbrk into ivbrk where vbeln in s_vbeln

select kunnr name1 regio from kna1 for all entries in ivbrk where kunnr = ivbrk-kunag.

loop at ivbrk.

read table ikna1 with keykunnr = ivbrk-kunag.

if sy-subrc = 0.

ivbrk-regio = ikna1-regio.

endif.

modify ivbrk transporting regio.

endloop.

2. select * from vbrk into ivbrk where vbeln in s_vbeln

loop at ivbrk.

select single regio name1 from kna1 into (v_regio,v_name1) where kunnr = ivbrk-kunag.

ivbrk-regio = v_regio.

modify ivbrk transporting regio.

endloop.

in first one im selcting datas in ikna1 by select statement and within loop endloop am reading the internal table ikna1.

in second one within loop and endloop and using select single to to fetch data from kna1.

here everytime am hitting database table using select single.

So can you please tell me which is correct for improving the performance tunning.

regards,

Ramya

Re: Performance Tuning

Former Member — Tue, 21 Aug 2007 11:46:50 GMT

first one is better

Re: Performance Tuning

Former Member — Tue, 21 Aug 2007 11:47:11 GMT

first one is correct. it will definitely improve perfomance.

Sameer

Re: Performance Tuning

Former Member — Tue, 21 Aug 2007 11:50:15 GMT

use first one and modify like this

select * from vbrk into TABLE ivbrk where vbeln in s_vbeln.

SORT IVBRK.

DELETE ADJACENT DUPLICATES FROM IVBRK COMPARING KUNNR.

IF IVBRK[] IS NOT INITIAL.

select kunnr name1 regio from kna1INTO TABLE IKNA1 for all entries in ivbrk where kunnr = ivbrk-kunag.

ENDIF.

loop at ivbrk.

read table ikna1 with key kunnr = ivbrk-kunag.

if sy-subrc = 0.

ivbrk-regio = ikna1-regio.

endif.

modify ivbrk transporting regio.

CLEAR IVBRK,IKNA1.

endloop.

reward points to all helpful answers

kiran.M

Re: Performance Tuning

Former Member — Tue, 21 Aug 2007 11:56:41 GMT

Ramya

CLOSE THIS THREAD IF SOLVED