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?
Discussion posts and replies are publicly visible
I always ask at this point *why* you want to export the data? It's much better left where it is. As soon as you export it, it's out of date. If you need to use it for reporting (a common use case) you can point your tools at the data in situ rather than move the data to the tools.
© 2021 Appian. All rights reserved.