topic Performance issue - Function modules ( query) vs Perform - form(int table ) in Application Development and Automation Discussions

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

Former Member — Tue, 11 Jul 2006 07:17:19 GMT

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

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

Former Member — Tue, 11 Jul 2006 07:42:48 GMT

Raja,

Can you check few points related to your program which affects performmance.

1)LOOP inside anotherloop.

2) select inside loop.

3) read without sorting itab.

Cheers,

TM.

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

Former Member — Tue, 11 Jul 2006 07:46:10 GMT

reason could be that u are using without applying some good access techniques one could be binary search or hasing or using a sorted table

use binary search the most preferred technique

secondly if u have a select statement inside a loop

bring it outside the loop.

never code a select querry insde a loop endloop statement

Definitely performance will improve

Harish

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

andreas_mann3 — Tue, 11 Jul 2006 08:13:21 GMT

hi,

use sorted or hashed tables for inside-loops

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

Former Member — Tue, 11 Jul 2006 09:33:53 GMT

Hi,

performance is the Main issue for ababers. to avoid such performance problems, plz take the follwing.

1. Dont Use 'not equal to' condition in select query

2. Dont Use nested loop structure

3. Dont Use select *

4. Dont Use nested select

5. Select the tables (for Eg Instead of Bseg , plz use

Bsis,bsas

6. Instead of nested Loop , plz use Read table command.

Thanks,

Neptune.M

Plz Reward if it helps.

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

Former Member — Tue, 11 Jul 2006 13:12:47 GMT

Check <a href="/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops">this blog.</a>

Rob

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

LucianoBentiveg — Tue, 11 Jul 2006 13:27:14 GMT

You can use Abovesoft utilities, to improve your code performance. See releated link:

<a href="http://www.abovesoft.com">http://www.abovesoft.com</a>

Regards.