Skip to Content
0
Former Member
Jul 11, 2006 at 07:17 AM

Performance issue - Function modules ( query) vs Perform - form(int table )

67 Views

Hi all,

Currently i worked in data maigration.one of my colleague migrated the datas by using custom developed fuction modules with driver program .it migrates the datas volume of some 1 lakh records with different conditions within 20 mins.

i have developed one report for reconcillation of that datas using the same migration logic.Instead of function modules i utillized the perform-form local routines .

In migration function modules ,within loop all queries of function modules are executing.but that produces the desired result.

I changed that querys in my program ,i accumulated all the datas initially in the internal tables .i utillized that using read statements.

if i use some 500 records ,that report comes properly within 2 mins.if i go above 500 records that loop becomes infinite.report comes after 1 hour.here there is no data problems.i already checked the datas.

if anybody knows the solution for this ,please let me know

thanks in advance,

raj