Response Time Exceeds Threshold (Appian Health Check Risk)

hiteshd

Certified Lead Developer

over 8 years ago

Hi All,

We are getting lot of high risk items in health check stating 'average response duration over 2000ms'. Most of these interactions are happening with a database which is held on another network and Appian being on Cloud and we are using smart service to call the stored procedure from Appian on this DB or queryentity on DB views.

I believe it is taking more time for the response because of the network as most of these are simple procedures or views with no complex logic. Is there any way we can improve this and get these health check issues resolved without network related changes.

Any suggestions/improvements welcomed:)

Thanks.
Hitesh

Discussion posts and replies are publicly visible

0 Ravi over 8 years ago

Hi Hitesh,
For all long running queries, you can add foreigh keys and indexes to the DB Columns whereever require. And run explain command against to the view to verify the status of the query. This way you can improvise the performance and get rid of few db query issues
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 hiteshd
Certified Lead Developer
over 8 years ago

Thanks Ravi.

We have already optimized the queries and views and it is just taking few ms when executed independantly on DB. The issue comes when the result comes back to Appian (On Cloud) from DB which is sitting on another network and both are connected via VPN Tunnel.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 gautams778
Certified Lead Developer
over 8 years ago

See the recommended database performance best practices page

forum.appian.com/.../Database_Performance_Best_Practices.html

If no issue on DB end, Please check the network latency using the browser tools (F12/Network).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel