topic Re: Program execution taking a long time in Application Development and Automation Discussions

Program execution taking a long time

Former Member — Thu, 12 Aug 2010 15:10:31 GMT

Hi Experts

We have a program which has a loop inside which; in order to optimize the performance,

we have used read statements with Binary Search after sorting the internal tables.

The code inside the loop contains multiple read statements (as mentioned) followed by one BDC and one Update statement.

When we executed the program by scheduling it in background it took 33000 seconds to execute; which is around 9 hours which is not acceptable.

Mentioned herewith are the findings which might help you to analyze and propose the solution.

1) Records in scope for the program to process : 45000

2) We have also noticed that the time taken for processing a fixed number of records increases gradually with the passage of time.

for example:

the 1st 100 records executed in 25secs

next 100 records executed in 75secs

the next 100 in 100 secs and ....... the gradual increase continues.

Just for your information sake: there are no select queries inside the loop ... endloop.

Kindly provide a solution.

Thanks and Regards

Avishek

Re: Program execution taking a long time

HermannGahm — Thu, 12 Aug 2010 17:05:36 GMT

Hi,

have you traced the program (SE30, ST12) in order to see where the time is spent?

Once you found the time consumers you can think about (or ask for help) how to optimize...

Kind regards,

Hermann

Re: Program execution taking a long time

Former Member — Fri, 13 Aug 2010 13:39:19 GMT

can't wait to see some code!

Re: Program execution taking a long time

Former Member — Fri, 13 Aug 2010 17:19:49 GMT

Avishek,

check this thread

Thanks

Bala Duvvuri

Re: Program execution taking a long time

samantak_chatterjee — Sun, 15 Aug 2010 04:18:06 GMT

Hi Avishek,

Is there any other of optimizing the code by way of local table buffering, using field symbols, etc. The above mentioned things are a part of the general coding guidelines and will help to optimize the code performance.

Hope this helps.

Thanks,

Samantak.

Re: Program execution taking a long time

Former Member — Sun, 15 Aug 2010 22:42:35 GMT

Hi Avishek,

Increasing time, it's a strange behavior here on your description.

Questions:

1) This BDC is standard?

2) Are you refreshing BDC before set it again?

3) This UPDATE have index support or it always run a sequencial access on databases?

4) You need execute this sequencially or you can take advantage of app servers running in parallel?

Regards, Fernando Da Ró

Re: Program execution taking a long time

Former Member — Mon, 16 Aug 2010 08:28:25 GMT

Hi Avishek,

I agree with Fernando. You may try using a Function Module for BDC and Update, which will get called in parallel procress.

You can call the function Module for a set of 100 - 500 records.

Thanks,

Preyansh

Re: Program execution taking a long time

Former Member — Tue, 17 Aug 2010 08:02:44 GMT

please show the code, change name if you don't want to show internals.

Re: Program execution taking a long time

Former Member — Thu, 02 Sep 2010 11:42:11 GMT

can we using cursor?

Re: Program execution taking a long time

former_member193284 — Sat, 18 Sep 2010 21:07:29 GMT

Hello,

I would suggest to perform following steps to optimize your code.

Please run SE30 runtime analysis and figure out if ABAP/Database/System is taking time

Also run Code inspector & Extended program check to remove all warnings errors

Then run ST05 and figure out if any select query is taking time. In this case use secondary index if required.

If you have select query's in your program avoid correponding clause and ensure you select fields in the order they are defined in the database tables... you internal table structure should match the sequence.

try and use for all entries if required.

restrict your database selects by ensuring you dont select unwanted records while data fetching.

Regarding ABAP code.

Use binary search..

clear your work areas and internal tables

try and use field symbols if your modyfing internal tables

if possible your views

Hope this helps you

Have a nice day

Thanks

Sumit

Re: Program execution taking a long time

kesavadas_thekkillath — Sat, 18 Sep 2010 22:17:03 GMT

If you have standard BAPI's available then avoid BDC and go for that, you can see the difference in the execution time.

@-Aniesh - Cursors never improve the execution time !!! .


the 1st 100 records executed in 25secs
next 100 records executed in 75secs
the next 100 in 100 secs and

You have told that you are using read statement inside the loop, that too it triggers multiple times.

have you checked how many times it gets triggered for the above three steps ?

And donot expect a mass upload program to get finished within a short time