2009 Jul 14 7:47 AM
Hi all,
i had devoloped one report which is dynamic ALV grid.when i am executing it in SE 30
i am getting bellow percenrege of each performence,
ABAP ---96.6%,
Data Bsae--00.9%,
Syesm-02.5 %,
i want to decrease ABAP 96.6% to 65%. i want to know how to do it?
i had freed all internal tables and work areas and variable.please help me.
Thanks in advance
Ravinder
2009 Jul 16 8:49 AM
Why do you want to reduce it to 65%?! That performance breakdown looks pretty good to me as most of your time is spent within ABAP.
If you reduced your ABAP processing to 65% from 96.6% then the database and system aspects would have to increase by 31.6% to balance out - you still need to get to 100%!
Or do you really mean you want to reduce the actual time taken for the program to run?
2009 Jul 14 7:56 AM
Hi,
You can follow the following steps to reduce ABAP processing time.
1. Sort the internal tables and use binary search with read statements.
2. Avoid nested loops if possible.
3. Make use of field-symbols to modify internal tables instead of modify statements.
4. Free the internal tables and work areas when not required.
5. While looping give the index if possible.
These are just few recommendations.
Follow the examples in Tips and Tricks in SE30 for more details.
Regards,
Ankur Parab
2009 Jul 14 8:03 AM
Dear Ravinder,
After Executing the Program in SE30, click on ANALYZE Button.
It will display the statics.
At top left corner, click on the displayed icon.
System will display the complete statics.
Sort the details in by selecting NET (%) and check the queries taking more time.
Accordingly use performance tuning of the code.
Thus database and ABAP % can be reduced.
Regds,
Anil
2009 Jul 14 8:19 AM
Use the result of the analysis,
- Find the more CPU consuming forms (sort result by net percentage)
- Find if some FM or form are called multiple times with same parameters, if yes buffer the result
- Optimize internal tables access, SORT table which are accessed via READ TABLE and use BINARY SEARCH, if you use some, LOOP WHERE, define table as SORTED with adequate keys
- look at
Regards,
Raymond
2009 Jul 16 8:49 AM
Why do you want to reduce it to 65%?! That performance breakdown looks pretty good to me as most of your time is spent within ABAP.
If you reduced your ABAP processing to 65% from 96.6% then the database and system aspects would have to increase by 31.6% to balance out - you still need to get to 100%!
Or do you really mean you want to reduce the actual time taken for the program to run?
2009 Jul 16 10:45 AM
Dear Ravindar,
Go to st05 and give a trace for u r program..
Can u check where the system is taking too much time to execute.
Please copy that code here.
With Regards,
Sumodh.P