Will that query entity fetch 10,000 records at a time ? And What is the best approach do you follow to get that large set of data from database ?
Discussion posts and replies are publicly visible
It dependents on the volume of data, ex you querying a table which have only 3 columns vs 50 columns. When querying tables we need to follow certain best practices
Appian is not meant to load huge volumes of data into memory. You will need to adapt your solution approach to the nature of the platform.
As Stefan Suggested do not load so much of data in Appian, use the paging info to control your dataset.
© 2022 Appian. All rights reserved.