Improving database performance
Monitor your database so that it robustly supports a production-level application. Modify your database to support quick data retrieval and to increase column lengths as your initial requirements change.
- Understanding the database structure
The Pega Platform database and the tables within it are structured in a unique way. By understanding how the database is structured, you are better able to support system updates and to be responsive to changes in data utilization.
- Viewing general database information
Access the System Database landing page by clicking Configure System Database . The following tabs are available:
- Viewing the database schema
You can view your database schema information for tables, columns, views, indexes, and schema changes.
- Creating database data instances
Create a database data instance so that Pega Platform can access a database in addition to PegaRULES and PegaDATA. To improve performance, you can create Pega classes and data types in a separate database, or use a separate database for Prediction Studio or for running reports. You can also create a database instance to access an external database.
- Optimizing database properties
You can improve reporting and search performance in your Pega application by optimizing (exposing) Single Value properties as distinct columns.
- Working with class groups
A class group data instance unifies a set of classes in the PegaRULES database that share a common name structure and common key structure. A class group causes all instances of these classes to be stored in one database table. As a result, processing can later convert an instance of any member class from its current class to another class within the class group, without affecting the key structure or changing the database table that holds the instance.
- Running SQL queries on Pega Cloud
As a Pega Cloud client, to retrieve data from the PegaDATA, PegaRULES, CustomerData, and ExternalMKTData (when using the Pega Marketing applicationns) databases, you can run SELECT statements using Query Runner.
- Archiving and expunging case data
Configure case archiving to move historical case data from your database to a secondary file storage repository, such as the Pega Cloud File storage repository in Pega Cloud deployments or an S3 repository in On-premises and client-managed cloud deployments.
- Troubleshooting database requests
The Pega Platform database performance is a major factor in overall system performance, affecting response time for interactive, browser-based users, turnaround time for services, and throughput. You can use tools provided by Pega Platform to help you debug, trace, and analyze requests from the server to the Pega Platform database.
Previous topic Predictive Diagnostic Cloud Next topic Understanding the database structure