I'm using view to get different columns from two tables and using that view to generate the report in excel.
So my question is : After the 5-6 years the data will be large inside the view which I'm using currently, so is there any alternate way to get the data faster as compared to view in Appian.
Thank you.
Discussion posts and replies are publicly visible
If you use the plugin "Export Data Store Entity to Excel" I do not see any other option. It does not work with Appian synced records.
Somewhat overkill but if you *absolutely* want to avoid views, there is the option of doing a materialized view. Some DBMSes offer this option where the view can refresh itself (Oracle, SQL Server). Otherwise, you'd have to have a scheduled process that runs SQL or Stored Procs to refresh the data in the table periodically.
More info here: