Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
11 subscribers
Views
997 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
We are developing an entity backed record for Accounts. In each record view, the
mohamedb
over 8 years ago
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
Discussion posts and replies are publicly visible
0
abhi.jana
Appian Employee
over 8 years ago
I would recommend opening up a support case and work with the solution engineering team at Appian to investigate.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel