08-20-2007 4:12 PM
One of my report is moved to Quality and is having performance issues....
There are about 3-4 select statements..
What points do i need to check when i am doing performance analysis in Q- System.....
Thank you.
08-20-2007 4:13 PM
Firstly you could use the search facility as this has been asked many many many times.
08-20-2007 4:19 PM
Hi,
run RTA or sql trace and see what is taking more time.. either select statement or the rest of the code.. if it is the select statement.. check to see if you are using proper primary keys on the select.. if it is in the program code other than the select then check to see if you can avoide too many loops. and see if you have read staements and u r uing the binary search functionlaity..
Thanks
mahesh
08-20-2007 4:21 PM
1 Selection CriteriaUser should enter several different sets of selection criteria, and try different radio buttons. For example, run with and without blanket orders. If there are match code buttons, try to access the list of possible selection criteria. If you normally use a report variant, please test that.Does selection criteria work properly?
2 HeaderAfter the report is executed, the user should review the information shown in the report Header. Is it accurate? Is key information included?Does accurate header information appear? Is key information included in header?
3 Body Is the information in the body of the report accurate? Is key information included in the body of the report? For summary level reports, the information should be compared to the summary statement, DTR, and/or GL44 to check accuracy.
4 Subtotals/TotalsAre the subtotals correct? Are the totals correct? Are calculated charges accurate on actuals Are calculated charges accurate on commitments?
5 DrilldownIf the report has drilldown functionality, try drilling down to various information.Does drilldown bring you to an appropriate location? Is the drilldown accurate?
6 Expand/CollapseIf there are expand and collapse buttons, try expanding and collapsing on various areas.Does the expand and collapse work properly?
7 Sorting/ConsolidatingIf the report provides sorting or consolidating, try both on various sections.Does the report sort properly? Does the data consolidate properly?
8 Download If there is download functionality, download the report and save as a local file. Compare the downloaded file to the displayed report.Does the file download properly? Does the downloaded report match the report output?
9 Other Report Toolbar ButtonsIf the report has other buttons on the toolbar check that they work properly. Do the other report tool bar buttons behave as expected?
10 SAP Toolbar ButtonsWhile displaying the report try the buttons on the SAP toolbar. These buttons include the back arrow, the cancel button, exit, etc.Do the SAP tool bar buttons behave as expected?
11 Printing Print the report and check the printout for accuracy. If there are different print options (such as portrait and landscape) print the report in both layouts to make sure the printouts are correct. Does the format look correct? Does the report properly print the portrait layout? Does the report properly print the landscape layout? Does the printed report include all the required report information? Do key master data fields on the printed report match the screen output? Do the totals on the printed report match the screen output? Do the subtotals on the printed report match the screen output?
regards,
srinivas
<b>*reward for useful answers*</b>
08-20-2007 4:40 PM
Run SE30/ABAP Runtime Trace, check Top 10.
... use search ... I explained the basic usage somewhere else.
Siegfried