When running database views on large data like 8000 lines; it takes a very long

mohamedb over 10 years ago

When running database views on large data like 8000 lines; it takes a very long time to execute the view. Are there any known database optimization techniques to optimize mySQL DB with Appian cloud? ...

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 10 years ago

Try monitoring the SQL execution on the MYSql admin console to identify the execution tree of the queries being executed. Once you have the info, you can try and optimize them using index or other optimisation options based on the behaviour. This would help you get started.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 10 years ago

Thanks Sathya ... that made my day!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel