Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Improving database performance

Updated on July 8, 2022

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.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us