Application performance
To ensure optimal performance under difficult load and volume conditions, Pega Client Lifecycle Management and KYC comes with database indexes in relevant tables and
columns. Certain database indexes cannot be automatically created in all the environments and
database vendors. The table below contains some database indexes to address common
performance related issues that, depending on your environment, load and use of the
system, you might be experiencing. pc_data_workattach Associateinfo varchar_pattern_ops pxobjclass pc_data_workattach pxinsname varchar_pattern_ops pxobjclass pc_work_masterprofile pyid varchar_pattern_ops Oracle PostgreSQL pc_work_masterprofile UPPER(customertype) In the case of an upgrade, specific database column mappings need to be added
manually to the classes of your implementation layer. These mappings ensure that the
application works and performs as expected. Determine the items from the list below that apply to you. For each of them, open the
equivalent class at your implementation layer (for example, using below UPlus) and
register them in the External Mapping tab.Database indexes
Database Table/Columns Action PostgreSQL Regenerate existing index on these columns to add the
varchar_pattern_ops option. PostgreSQL Regenerate existing index on these columns to add the
varchar_pattern_ops option. PostgreSQL Create index on this column and set the
varchar_pattern_ops option. Regenerate existing index in this column to use UPPER
function. Database column mappings
Upgrade from 8.4 version or earlier
Functional area Class Column name Property name Group Management UPlus-Work-CLM GroupID_2 .GroupInfo.GroupID Group Management UPlus-Work-CLM GroupName_1 .GroupInfo.GroupName Group Management UPlus-Work-CLM-GroupManagement GroupID_1 .GroupEntity.GroupID Group Management UPlus-Work-CLM-GroupManagement GroupID_2 .GroupInfo.GroupID Group Management UPlus-Work-CLM-GroupManagement GroupName_1 .GroupInfo.GroupName
Previous topic Generating a PDF documentation Next topic Reference