Skip to main content
Contact a Moderator

Question

2
Replies
2096
Views
 voon keong lum (voonkeongl)
Kelly Services Malaysia Sdn. Bhd.

Kelly Services Malaysia Sdn. Bhd.
MY
voonkeongl Member since 2017 12 posts
Kelly Services Malaysia Sdn. Bhd.
Posted: April 9, 2018
Last activity: April 11, 2018
Posted: 9 Apr 2018 23:20 EDT
Last activity: 11 Apr 2018 0:01 EDT
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
Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 3 years ago
Posted: 10 Apr 2018 14:51 EDT
Ron Lee (RonLee_GCS)
PEGA
Principal Software Solutions Engineer
Pegasystems Inc.
US

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?
Posted: 3 years ago
Posted: 10 Apr 2018 23:59 EDT
voon keong lum (voonkeongl)
Kelly Services Malaysia Sdn. Bhd.

Kelly Services Malaysia Sdn. Bhd.
MY

This was actually a question asked in the mock exam. We are conflicted on the answer, mainly because we come from .NET background and seems like Pega has a different concept on non-optimized/un-indexed fields

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice