performance

[Former Member]

How to improve performance of a report. My report is taking 1 hr to execute in production.

How to use SE30 and ST05 to improve......plz help

[former_member583013]

SM30 is used to measure function and table calls....Just pass the name of the report executed and watch the list....

To improve performance...a few tips...

* Never use SELECT-ENDSELECT.
* Try to use indexes.
* Use LOOP ASSIGNING
* Don't make unnecessary table reads

Greetings,

Blag.

[ferry_lianto]

Hi,

Please check this links ...

SE30:

http://help.sap.com/saphelp_nw04s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm

ST05:

http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/frameset.htm

http://www.datamanagementgroup.com/resources/Articles/Article_UsingSAPsSQLTraceTool.asp

http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html

Regards,

Ferry Lianto

[Former Member]

hi,

Check out this thread

https://forums.sdn.sap.com/click.jspa?searchID=2440381&messageID=2572547