on 01-28-2011 5:39 PM
how can we improve the performance for reporting
Hi Try this to improve the performance for reporting:
1.Using 'For all entries' in the table makes internal reprocessing and reading of data fast.
2.Sort the table .
3.while using read statement use binary search.
4.Avoid using Select * in table that have a lot of fields.
5.Do not use nested select for large amount of data.
6.Using table buffering improves the performance.
7.Use the GET RUN TIME command to help evaluate performance.
8.Generally, try to reduce I/O first, then memory, then CPU activity.
9.Use as many table keys as possible in the WHERE part of your select statements.
10.Use the SELECT SINGLE command whenever possible.
11.Avoid dead-code
12.Remove unnecessary code and redundant processing .
13.If you want to find the maximum, minimum, sum and average value or the count of a database column, use a select list with aggregate functions instead of computing the aggregates within the program.
14.If you process your data only once, use a SELECT-ENDSELECT loop instead of collecting data in an internal table with SELECT ... INTO TABLE.
15.use WHILE instead of a DO+EXIT-construction. WHILE is easier to understand and faster to execute.
16.CASE statements are clearer and a little faster than IF-constructions.
17.Calling methods of global classes is faster than calling function modules .
18.We can use various Tools available in SAP for performance problem
The runtime analysis (SE30)
SQL Trace (ST05)
Tips and Tricks tool
The performance database
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hai kishore,
to improve your query performance
1) reduce the usage of navigational attributes as possible
2) don't use no.of characteristics in report instead keep them in free characteristic
3) maintaining the aggregates will improve your performance
4) maintain the cube indexes without fail
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hope these links help u:
http://sapbibw2010.blogspot.com/2010/11/performance-issues-in-sap-bibw.html
http://wiki.sdn.sap.com/wiki/display/profile/BWsystemtuning
BI Accelerator is the first choice.If the client have BI Accelerator implemented. By Creating BIA indices we can improve Query Performance.
Yes, Aggregates wud generally enhance the perforemance of reports..Also see this:
http://help.sap.com/saphelp_nw04/helpdata/en/7d/eb683cc5e8ca68e10000000a114084/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi..
yet another way is to use aggregates so as to accelerate the response time of queries, by reducing the amount of data that must be read in the database for a navigation step.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Couple of Recommendations.
Search on this forum for Performance Tuning. This question has been addressed many times on the forums. You will find plenty of pointers for performance tuning.
Here is a link to a SDN article on Performance tuning in SAP BI that i have used in the past.
Good Luck.
MP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.