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.
Database indexes
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.
| Database | Table/Columns | Action |
| PostgreSQL | pc_data_workattach Associateinfo varchar_pattern_ops pxobjclass | Regenerate existing index on these columns to add the varchar_pattern_ops option. |
| PostgreSQL | pc_data_workattach pxinsname varchar_pattern_ops pxobjclass | Regenerate existing index on these columns to add the varchar_pattern_ops option. |
| PostgreSQL | pc_work_masterprofile pyid varchar_pattern_ops | Create index on this column and set the varchar_pattern_ops option. |
Oracle PostgreSQL | pc_work_masterprofile UPPER(customertype) | Regenerate existing index in this column to use UPPER function. |
Database column mappings
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.
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 Enabling users to simultaneously work on cases Next topic Reference