topic Performance Issue in Application Development and Automation Discussions

Performance Issue

Former Member — Sat, 01 Nov 2008 13:40:58 GMT

HI,

Which of the following is the fastest way to fill an internal table of the structure above.

a)	select field1 field2 into (itab-field1, itab-field2) 
       from ztable where field1 = '10'. 
Append itab. 
Endselect.

b)	select * from ztable 
       where field1 = '10'. 
Move ztable to wa. 
Append itab from wa. 
Endselect.

c)	select * into corresponding-fields of itab 
       from ztable where field1 = '10'.

d)	select * from ztable 
       where field1 = '10'. 
Append itab. 
Endselect.

e)	select * into table itab from ztable 
       where field1 = '10'.

Regards

Re: Performance Issue

Former Member — Sat, 01 Nov 2008 14:18:51 GMT

hi,

if u have only two fields, then use following code.

select field1 field2 into

(itab-field1, itab-field2)

from ztable where field1 = '10'.

Append itab.

Endselect.

Re: Performance Issue

Former Member — Sat, 01 Nov 2008 14:30:31 GMT

i feel you can go with E option only because you are using single select statement.

Also you can compare statements only when you have same requirement.

A,B,D have got additional statements like move append it will take definitely longer time . C will take more time than E as you are using into corresponding fields

Re: Performance Issue

shimon_tal — Sat, 01 Nov 2008 15:39:06 GMT

HI Ferry ,

My opinion is E , because u HIT the Database just one time ,

insted of doing loop (a,b,d).

C take more then D because the corresponding.

Regards

Re: Performance Issue

Former Member — Sat, 01 Nov 2008 18:30:26 GMT

Interview?

Rob

Re: Performance Issue

Former Member — Sat, 01 Nov 2008 18:33:46 GMT

nope, seems more like a written test, so might be certification

Re: Performance Issue

Former Member — Sat, 01 Nov 2008 18:39:57 GMT

It seems very similar to another question by another(?) individual.

Rob

Re: Performance Issue

Former Member — Sat, 01 Nov 2008 19:33:44 GMT

Correct.

Rather avoid Ferry Latino and Cosmo Kramer until he / she gets his / her act together, as per the forum rules.

Cheers,

Julius