Hello,
I am using Appian 21.2 on cloud version (MariaDB) and I have 2 Views:
1) one view with 30 columns and ~300k rows which works pretty fast2) second view with 85 columns and ~140k rows which takes around 8-9 seconds to load
I know that using the standard smart services you cannot have more than 50 columns and max 100k rows and whenever I use the smart service Export SQL To Excel it breaks "max_statement_time" exceeded.
Also querying a few rows from the second view won't be possible since it breaks.
Any idea for OOTB solutions?
Thank you!
Discussion posts and replies are publicly visible