Question

1
Replies
38
Views
Tony Tung (tungt)
PEGA
Lead System Architect
Pegasystems Inc.
AU
tungt Member since 2013 7 posts
PEGA
Posted: June 2, 2021
Last activity: June 5, 2021
Posted: 2 Jun 2021 6:12 EDT
Last activity: 5 Jun 2021 16:39 EDT

How to avoid reading pzpvstream?

hi,

    In a project of 8.5.1 I have defined a number of data types and configured their local data sources as tables in the PegaDATA schema.  I noted that all the properties I included in configuring the data source are exposed as columns in the underlying tables.  However, all the access to the records of the data type, either via data page or activities, are still reading the pzpvstream despite the fact that all properties are already exposed columns.  While this is functioning, it is causing poor performance.  Is there a way to suppress the reading of pzpvstream in the sql generated for data type without the need of deleting the pzpvstream column and restarting the whole system?

Thanks

***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Platform 8.5.1 System Administration Financial Services Lead System Architect