Question
2
Replies
504
Views
TechM
Posted: January 29, 2018
Last activity: January 29, 2018
Closed
Performance Issue-Unexposed property
Why its caused performance issue when we used unexposed property in a report. Kindly advice.
***Edited by Moderator Marissa to update categories***
Moderation Team has archived post,
Close popover
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.
Posted: 3 years ago
More explanation can be found in below link,
https://pdn.pega.com/when-use-%E2%80%94-and-when-not-use-%E2%80%94-unoptimized-properties-reports
Hi Naveen,
Generally the unexposed properties will be stored in the blob column and if you use this unexposed property in the report definition then it will report the guardrail warning related to the performance issue because each time the report is run the data related to that property need to be fetched from the blob column using the UDF's which takes time to fetch the data. So the system will throw this warning to optimize the property to avoid this performance delay.
Hope it is clear to you.
Regards
Mahesh