Export big data to xls, xlsx or csv

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 fast
2) 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