I have a need to use export to excel functionality feature for a report where data is supposed to retrieved from multiple(2) cdt.
Also, the dataset is extremely large.
What approach should i go for?
As per my understanding, Materialized view would be the best choice here.
As you said, you are going to deal with huge amount of data hence i wouldn't recommend you to go for View(as this prepares the data on demand by applying various joins and other set of logic) instead try to create a Materialized view to perform the query.
You can follow below mentioned steps to achieve your requirement to avoid any performance issues:
Hope this will help you.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.