09-01-2006 10:58 AM
Hii All,
The runtime analysis (SE30) of a program shows that the ABAP runtime is 68.9%; Database is 26.1% and system is 5% making an overall 100%.
Is it good performance? the ABAP bar is shown in red color. What can be done to reduce the ABAP runtime ( make it green colour) so that all ABAP, System, Database are in allowable percentages?
Thanks.
09-01-2006 10:59 AM
u can make better main is Database is 26.1% try to decrease it as much possible...
09-01-2006 11:02 AM
Hi,
You`ll have to cut down both on ur ABAP and DB statistics.
Carefully explore ur code and avoid unnecessary loops, if statements and try using field-symbols in place to variables.
Your select query should not take much time, use the primary keys of ur table in the where condition and avoid endselect.
Hope the info. is helpful. Reward if so.
Regards
09-01-2006 11:03 AM
hi Shakir,
for that look at your code and check for whether you have used select .. endselect or select within a loop or not sorted before any read table statement or avoiding joins ... there by you can increase the performance of your code and can make it to come in green color
Regards,
Santosh
09-01-2006 11:11 AM
Hi Shakir,
I think this quite a good analysis in terms of performance.
Because the main performance issues are alaways related to ur database , here it looks very fine so need to worry on that.
regarding ABAP u can check if u have used Read table .. with binary search this will reduce the ABAP %.
Reward if useful
Regards
kapil
09-01-2006 11:20 AM
From the percentage it looks fine...yes you can reduce the ABAP% by trying to use read statements with binary search or instead of corresponding fields use move for each field etc