Skip to main content
Contact a Moderator

Question

2
Replies
6440
Views
 Vimaladevi Moorthy (VimaladeviM)
infosys ltd

infosys ltd
US
VimaladeviM Member since 2015 16 posts
infosys ltd
Posted: May 3, 2016
Last activity: May 10, 2016
Posted: 3 May 2016 18:19 EDT
Last activity: 10 May 2016 11:24 EDT
Closed
Solved

Optimize for reporting

I do understand that if i create any case that is stored as BLOB field in the pega database table. If i do need to use any of the fields in the report i have optimize the field (exposing the field). Why do we need to optimize? what happens in the background if i optimize the property?

Message was edited by: Lochan to add Category

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: 5 years ago
Posted: 3 May 2016 22:07 EDT
Harish Gunneri (Harish_GCS)
PEGA
Senior Software Solutions Engineer
Pegasystems Inc.
US

Hi Vimala,

Retrieving/Extracting any property field value from the BLOB column is a costly DB operation and hence not recommended for reporting. Optimizing the property(exposing) creates a separate DB column on the particular table for faster access.

For more info, please refer to:- https://pdn.pega.com/sites/pdn.pega.com/files/help_v718/procomhelpmain.htm#tools/propertyoptimization/aboutpropertyoptim…

BR//

Harish

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