We are developing an entity backed record for Accounts. In each record view, the

We are developing an entity backed record for Accounts. In each record view, there is a Grid displaying account related customer information. The Grid gets its data from a database view. It joins 3 tables (Accounts, Customers and XREF-Accounts-Customers for the M-to-N relationship between the two tables).

The record view takes about 10 sec to load; which is very slow. This is after indexing the columns used in different query conditions. The network connection is pretty fast and queering the DB tables bring fast results.

The performance of DB as I query the view is about: 3.7 sec.
The performance of Appian with() function displaying the grid is about: 7.5 sec.

I am attaching the code and the performance results for you Appian folks to have a look. We have invested some good time trying different solutions. I hope you can help.

OriginalPostID-215168

OriginalPostID-215168