I have indexed all database columns of the three tables feeding the database vie

mohamedb over 8 years ago

I have indexed all database columns of the three tables feeding the database view this entity backed record grid is reading from. Still, the performance statistics show slow execution for the a!queryentity. I am attaching the numbers. Is this the norm Appian folks?

Discussion posts and replies are publicly visible

Parents

0 Jonathan Katora
Appian Employee
over 8 years ago

Those values seem really slow for a 20 row RDBMS query. From your expression, it looks like your constant is pointing to a view... is that correct? If so, you can look at the database performance logs to determine if your holdup is on the Appian side or RDBMS. See the performance troubleshooting section of this page:

forum.appian.com/.../Database_Performance_Best_Practices.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jonathan Katora
Appian Employee
over 8 years ago

Those values seem really slow for a 20 row RDBMS query. From your expression, it looks like your constant is pointing to a view... is that correct? If so, you can look at the database performance logs to determine if your holdup is on the Appian side or RDBMS. See the performance troubleshooting section of this page:

forum.appian.com/.../Database_Performance_Best_Practices.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data