We are currently facing a performance issue with our Pega Service REST integrations that interact with an AWS-hosted application. The AWS team has reported significantly slower response times when invoking APIs that retrieve data from Pega, particularly from the data type records table. These delays are noticeably higher compared to other AWS-hosted APIs and services.

From their analysis, there appears to be the time taken by Pega to retrieve and process the data before sending the response back to AWS was long.

Given this situation, we are exploring ways to optimize the performance of these API calls from the Pega side. Our main goal is to reduce response time and improve the efficiency of data retrieval for AWS-triggered service calls.

We would appreciate any guidance or recommendations on how to achieve better performance, including any design changes or configuration improvements in Pega or AWS that could help reduce latency.

If anyone has experienced similar issues or has insights based on their own implementations, your input would be greatly appreciated.

Thank you in advance!