topic Re: Executable program vs function module in Application Development and Automation Discussions

Executable program vs function module

Former Member — Tue, 18 May 2010 05:50:58 GMT

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?

Re: Executable program vs function module

Sandeep_Panghal — Tue, 18 May 2010 06:01:39 GMT

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.

Re: Executable program vs function module

former_member209217 — Tue, 18 May 2010 06:07:58 GMT

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.

Re: Executable program vs function module

rahul2000 — Tue, 18 May 2010 11:43:15 GMT

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

Rahul

Re: Executable program vs function module

kesavadas_thekkillath — Tue, 18 May 2010 13:05:24 GMT

Hi,

Why dont you check it once

Re: Executable program vs function module

JerryWang — Wed, 19 May 2010 03:43:34 GMT

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

Re: Executable program vs function module

umashankar_sahu — Wed, 19 May 2010 04:41:02 GMT

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.