topic Re: Improve performance in Application Development and Automation Discussions

Improve performance

Former Member — Thu, 18 Apr 2013 18:17:21 GMT

Hi All,

Can you please help me how to improve performance for the standard report RCF_DBCDCYL_INDEXING as it is taking long time to process .

Thanks in advance.

Regards,

Deep

Re: Improve performance

Former Member — Fri, 19 Apr 2013 04:10:05 GMT

Hi Deepthi,

For standard program we can't do much from ABAP end.You can schedule in background if it

takes long time.Check with basis team may be they can provide some help.

Re: Improve performance

Former Member — Fri, 19 Apr 2013 04:59:42 GMT

we can try with custom program using same logic and can we modify code which is taking long time to process.

Re: Improve performance

adam_krawczyk1 — Fri, 19 Apr 2013 05:42:36 GMT

Hi Deepthi,

You can search for OSS notes regarding this report, maybe some performance issues were already raised.

Although we are not so flexible with standard programs as with customized, you can try to do measurements with SAT/SE30 and ST05 transactions to see why exactly your program is running long time. If the problem is in database access (which is often the case), you can try to adjust indexes to improve database read performance.

Regards

Adam

Re: Improve performance

Former Member — Fri, 19 Apr 2013 06:07:28 GMT

Yes you can do but first try to find out which area of code is taking time using SQL Trace.

If possible try creating secondary Index if it resolves the Issue.I don't think Z program

will be much helpful.Keep it as last option.

Re: Improve performance

gouravkumar64 — Fri, 19 Apr 2013 06:58:59 GMT

Hi @deepthi ,

Check these sap notes & follow instructions to improve performance.

It may helps.

Note 1491289 - Performance of Dashboard Queries

Note 1426196 - Performance and functional corrections (SP06).

Thanks

Gourav.