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

 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

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 9 years ago
Posted: 3 May 2016 22:07 EDT
Harish Gunneri (Harish_Gunneri)
PEGA
Senior Principal Technical Support Engineer, 1:1 Customer Engagement
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://community.pega.com/sites/default/files/help_v718/procomhelpmain.htm

BR//

Harish

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