Question
2
Replies
1918
Views
Kelly Services Malaysia Sdn. Bhd.
Posted: April 9, 2018
Last activity: April 11, 2018
Closed
Solved
Report optimization for performance
You have been asked to create a list report that displays the following information: -Assigned case worker (.pxAssignedOperatorID)
-Requestor (.pxCreateOperator)
-Request date (.pxCreateDateTime) -Due date (.DueDate)
-Assigned vendor (.VendorName) The report contains two filters:
-Return purchase requests with a status (.pyStatusWork) of open.
-Return purchase requests when a department (.Department) matches the user’s department (.pxRequestor.pyUserIdentifier).
Which property, if not optimized, has the greatest impact on report performance?
Department / .DueDate .pxRequestor.pyUserIdentifier .VendorName
May I know what would be the best answer for this question? I think it's Department but I am not sure. Thanks
Within the context you've described, I would agree that it would be Department, as it is involved in the filter for the list results. Presumably you would want to expose this and index the resulting column for optimal performance.
However, any additional factors you have not stated could have an impact on the overall performance, like enabling column sorting and/or filtering on the grid that is displaying the results.
I'm not sure what the context of your question is. Why do you want to know which un-optimized property would have the greatest performance impact?