topic Runtime analysis in Application Development and Automation Discussions

Runtime analysis

Former Member — Wed, 24 Oct 2007 07:06:32 GMT

How to reduse ABAP and Database Execution Time in Runtime Analysis to increae Performance Issue

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 07:14:00 GMT

Hi Chaaya,

Its depend on code to code basis.

If you paste your code and tell where its taking maximum time we may help you.

Regards,

Atish

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 07:18:28 GMT

Dear Chaya

Please contact me on my contact no:-09930159222,09322129683 i will guide you what to do.

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 07:18:48 GMT

Hi,

you can calculate runtime like this:

TABLES: MARA.

Messungs von Laufzeiten zwischen Anweisungen.

DATA: UZEIT LIKE SY-UZEIT.

DATA: DATUM LIKE SY-DATUM.

DATA: MMSEC TYPE I.

DATA: LF_TIMESTAMP TYPE TIMESTAMP.

Beim 1. Aufruf von get rfun time ist mmsec 0.

GET RUN TIME FIELD MMSEC.

GET TIME STAMP FIELD LF_TIMESTAMP.

CONVERT TIME STAMP LF_TIMESTAMP

TIME ZONE SY-ZONLO

INTO

DATE DATUM

TIME UZEIT.

WRITE: / DATUM, UZEIT, MMSEC.

SELECT * FROM MARA.

ENDSELECT.

GET RUN TIME FIELD MMSEC.

GET TIME STAMP FIELD LF_TIMESTAMP.

CONVERT TIME STAMP LF_TIMESTAMP

TIME ZONE SY-ZONLO

INTO

DATE DATUM

TIME UZEIT.

WRITE: / DATUM, UZEIT, MMSEC.

Here you can get performance-examples:

SE38->ENVIRONMENT->EXAMPLES->PERFORMANCE EXAMPLES

Hope it helps.

Regards, Dieter

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 07:18:51 GMT

Dear Chaya

Please contact me on my contact no:-09930159222,09322129683 i will guide you what to do.

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 07:22:31 GMT

Hi Chaaya,

Please refer the following links for code efficiency guidelines.

http://www.sap-basis-abap.com/abap/abap-4-development-code-efficiency-guidelines.htm

http://www.sap-basis-abap.com/abap/performance-tuning-in-programming-abap.htm

Reward points for useful answers

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 08:08:47 GMT

Some ways of Increasing Performance!!1

1. try to avoid using select inside loop.

2. Read internal table with Binary Search

3. Instead of Inner Join Use For All entries

4. Try to give many fields in where condition

U can check ST05 to see which select stmt taking more time and accordingly u can modify ur code.

Praveen

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 08:11:33 GMT

use se30 sto5 and slin tcodes for performance issues

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 08:18:15 GMT

If you have any specific code, please send it to us, then we will review it and let you know..

You need to consider the follwoing points..

1. You have to write a proper select statements using the possible index fields in the where condition.

2. you have to avoid the nested selects.

3, you have to avoid the selects with in a loop..

please send us the code you have, we will do our analysis and let you know..

Reward the points if it is helpful..

Re: Runtime analysis

Former Member — Wed, 24 Oct 2007 11:23:03 GMT

If you have specific program , then the best way I know is just to test this program.

I will start as follows:

(1) execute program

(2) check STAD entries for this program - depending on the program you might have one or several entries (single records). It should be easy to find them

(3) check where is the problem --- general rules here: CPU < 40%, DB time <40%, but it depends on what kind of transaction you execute

(4) When you detected where is the problem (SQL or CPU), then use proper tools to go into details--> ST05 for SQL problems, SE30 or ST12 for ABAP (high CPU)

Not all performance problems are due to wrong coding! Some problems may happen because of the wrong or missing index on database.

There might be some general rules how to write good programs (good performance), but there is no better way to verify than testing!

regards

Rafal