Question
1
Replies
46
Views
Posted: 4 weeks ago
Last activity: 3 weeks 6 days ago
How to route read traffic to a separate DB instance from Pega application
In order to improve performance on DB interaction, We would need to route read traffic to a different instance so the primary instance can be used for other inserts/update/delete transactions. We already have read replica configured on the DB side. Need more information on how we can configure application content = read-only so Pega can identify and route all select queries to a different connection string.
If you are reading the data using report definitions, then you can configure the alternate database for reporting and update the Data retrieval preferences in Report definition.