topic Ideal execution time for any program in Application Development and Automation Discussions

Ideal execution time for any program

Former Member — Tue, 07 Aug 2007 09:20:44 GMT

Hi,

Is there any method to determine the ideal execution time for a program ?

Or else how to determine that ?

I just wanted the max. time that a program can take so that the performance would not be hampered.

Thanks,

Binay.

Re: Ideal execution time for any program

gopi_narendra — Tue, 07 Aug 2007 09:25:44 GMT

SE30 - Run Time Analysis tells you the ABAP, Database, R/3 System Performances.

Goto SE30 Tcode -- > Give in the program name and Press Execute Button.

Once the prog got executed, press Back and click on the

Analyze button.

This shows you the performance.

Regards

Gopi

Re: Ideal execution time for any program

Former Member — Tue, 07 Aug 2007 09:27:21 GMT

you are asking a lot of questions

No, it is not possible to determine an ideal execution time.

You can only check whether there is improvement potential and finally if you think that there is not potential anymore, then you should have reach the ideal execution time.

In SAP environment, especially the SD benchmark scenario is optimized up to the last bit of optimization potential. The scenario is then used for benchmarking hardware, results can be found on the SAP pages.

Siegfried

Re: Ideal execution time for any program

Former Member — Tue, 07 Aug 2007 09:33:13 GMT

If you only want to compare execution times you can run them both in batch and the logs will show you the run times. If you want to compare in more detail use transaction SE30 to run each of your programs. This will tell you how cpu times compare and will indicate hotspots within each program, eg bad areas of code or bad sql use etc.

Regards

Re: Ideal execution time for any program

Former Member — Tue, 07 Aug 2007 10:18:13 GMT

did you ask for the 'ideal execution time' or 'how to measure execution times'?

The second question was answered in one of your other questions.

Optimization:

Do SQL Trace, go to Summary by SQL statement, check 10 Top contributions (time = duration).

Try to optimize them, note minimal time per record, if larger than 10.000 microsecodns, then you should index usage.

Do SE30, go to hit list, sort by net time, again address 10 Top contributions, try to optimize, check the coding.

Do optimization and trace again, check again 10 Top contributions ....

Siegfried