RD

General
,
1

Hi,

What are the best practices for optimizing the performance of report definitions in Pega?

2

Hi @vinnuk17205500,

To optimize the performance of report definitions in Pega, follow these best practices:

  1. Use Indexes: Ensure relevant properties used in filters, sorting, and grouping are indexed.
  2. Limit Results: Apply filters to reduce the dataset size fetched by the report.
  3. Aggregate in Database: Utilize database functions for aggregation rather than in-memory processing.
  4. Avoid Heavy Calculations: Minimize complex calculations within the report definition; use declarative expressions or pre-aggregated data where possible.
  5. Scheduled Data Pages: Use scheduled data pages to pre-load data used frequently in reports.
  6. Cache Data: Configure data pages and report definitions to cache results for reuse.
  7. Monitor Performance: Regularly monitor and analyze report performance using tools like Pega Predictive Diagnostic Cloud (PDC) or performance alerts.

Implementing these practices will enhance report performance and improve overall system efficiency in Pega.

Thanks

Akhila

3

@vinnuk17205500 Below are major points:

1.Avoid heavy load of data.

2.Use Declare index for aggregate properties.

3.Limited results

4.Using data pages when possible

5.Avoid outer joins