Executable program vs function module

[Former Member]

hi gurus,

i have a question with regards to Executable programs vs function modules.

when we create a SELECT statement in an executable program, does it run slower as compared to the same SELECT statement, but is residing in a function module?

if there are any differences in terms of speed, which one is faster? better? and why? are they executed in different memory space? which one is more resource intensive?

[Sandeep_Panghal]

when we create a SELECT statement in an executable program, does it run slower as compared to the same SELECT statement, but is residing in a function module? => It should be same.

if there are any differences in terms of speed, which one is faster? better? and why? => Only advantage i see in using FM only for a SELECT statement is reusability.

are they executed in different memory space? which one is more resource intensive?=? FM will be excuted in new LUW.

[former_member209217]

Hi,

Both SELECT statements will take the same time irrespective of whether you are using it in FM or Report. Execution time of SELECT query depends on the Database Table Size (Number of records) and how effective your SELECT query is...

The only advantage of Using it in FM is its reusability in any executable program .

Regards,

Lakshman.

[rahul2000]

Does not matter.The execution time will not be hampered.

Rahul

[kesavadas_thekkillath]

Hi,

Why dont you check it once

[JerryWang]

Hello AbeCayago ,

You can try it yourself, you can make a runtime analysis using SE30 and ST05, and then you can get answer

Best Regards,

Jerry

[umashankar_sahu]

Hello Dear,

There is no impact in memory spacing and speed of data selection.

Function Module are used for code modularisation.

your speeding of select statement dependent on what basis your selecting data using how many Key access and/or Index Access.