Improve performance

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[adam_krawczyk1]

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

[gouravkumar64]

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.