topic performance help in Application Development and Automation Discussions

performance help

Former Member — Tue, 10 Jun 2008 18:30:55 GMT

Hi,

I have created a new interface. I want to do performance test for that report like if I want to run the report for 3000 employees how much time it will take.. How much time each line of code is taking and what are the other options to increase the perofmnace of report.

step by step procedure will help a lot or a document

Thanks.

Re: performance help

valter_oliveira — Tue, 10 Jun 2008 18:41:02 GMT

Hello.

For that you can use several options:

1 - Run tcode ST05 and check performance of database access

2 - Run tcode SE30 and test your code parts

3 - Use statement GET TIME at the begining and end of specific parts of your code to compare execution time

Regards.

Valter Oliveira.

Re: performance help

Former Member — Tue, 10 Jun 2008 18:47:17 GMT

Perform Runtime Analysis( SE30) and Sql Trace ( ST05 )

Run Time Analyser

http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm

SQL trace

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Re: performance help

Former Member — Wed, 11 Jun 2008 04:08:06 GMT

Hi,

Along with ST05, you could also do an extended program check and code inspector check for the program. The code inspector will give you errors or warning for select statements which can be optimised.

Shruthi