Ledger Agent - Slow Performance in executing simple queries

Summary:

Ledger Agent - Slow Performance in executing simple queries

Content (please ensure you mask any confidential information):

Hi All,

We would like to check if anyone else has encountered slow performance in Ledger Agent's query execution for simple queries?

For a simple query such as Ending Balance Account XXXXXX for Entity XXXX in Period ****-YY. which took over 1 to 2 minutes where if I used SmartView refresh, it is within a few seconds.

In addition, we can not input Openning Balance, Period Activity and Ending Balance in one query as it will not work. Hence, we have to use different query whereas in SmartView we can see all Openning Balance, Period Activity and Ending Balance on the same page.