topic Re: Performance in Application Development and Automation Discussions

Performance

p291102 — Tue, 15 May 2007 08:24:26 GMT

Hi ,

We need to analyze the performance of our ABAP team and their various reports based on performance , SE30 , ST05 will give some results , How to measure a program and say it is performance wise good ? Take for example you have 4 reports and say which report is good on terms of performance ?

Re: Performance

Former Member — Tue, 15 May 2007 09:17:48 GMT

When using SE30, the database count should be minimum , system should be minimum but its good to have maximum count for ABAP.

For SQL Trce, if you query is not optimised, it will be displayed in red/pink color.

This means it need attention.

YOu can improve the performance of select query by using all the primary keys and in the same sequence as they are in the table.

If in the where clause, you dont require a perticular primary key, you can use a blank range for the same.

Hope this answers your query.

regads,

Re: Performance

former_member5350 — Tue, 15 May 2007 09:23:17 GMT

hi sankar,

just some thoughts on your question:

focus on those code fragments and routines ( like FORM ... ) that do take very long to run.

check wheter you have nested loops and replace them by appropriate logic.

check how you access internal tables ( best is READ... BINARY SEARCH or READ... INDEX ... )

delete all unused code / variables

avoid SELECT - Statements and insert/update operations within loops as well as you should generally avoid access database - rather operate with an internal table representing database table and then modify databasetable from internal table at one single operation.

you may also have a look in the "Performance & Tuning" section of SDN forums,

please award points if helpful!

Clemens

Re: Performance

Former Member — Tue, 15 May 2007 09:23:38 GMT

hi,

<b> Performance of a program decreases much if the number of database hits are more.</b>

go to SE30, Runtime analysis and execute the program and analyze the reports given by system. Click on Hit List to know complete usage of memory and hits to database for different subroutines.

Regards

Sailaja.

Re: Performance

Former Member — Tue, 15 May 2007 09:26:59 GMT

who would do such a thing? Performance is always measured against the requirement.

a report with an answer time of 10 minutes is performing great, if it has to modify e.G. 3 million MARC records witha value that maybe has still to be calculated by a timewasting algorythm.

while another report running in 0.1 seconds is still to be called NOT performative cause all it does is reading e.G. ONE SINGLE record of a customizing table.

And well the Customer is the King, as long as there is no requirement to enhance the performance of a report, you shouldnt do it.

No requirement -> no order -> no money paid but still the chance to implement new faults.