Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 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: Apr 9, 2018
Last activity: Apr 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
To see attachments, please log in.
Reporting

Accepted Solution

Posted: 6 years ago
Posted: 10 Apr 2018 14:51 EDT
Ron Lee (RonLee_GCS) 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?

To see attachments, please log in.
Posted: 6 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

To see attachments, please log in.

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