performance help

[Former Member]

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.

[valter_oliveira]

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.

[Former Member]

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

[Former Member]

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