Export Data Store Entity to excel taking too much time

Why is this a problem? The only alternative, I think, is to directly export from DB to Excel. But then you have less options.

What is your DS pointing to and what is the goal or business need for exporting? Exporting indicates that you are taking the information externally from Appian for more passive viewing. Can you look at other options like use the data pipeline https://docs.appian.com/suite/help/23.1/Enhanced_Data_Pipeline_for_Appian_Cloud.html to pull DB data to another system for ad-hoc reporting as an example? Of persist the data to a System of Record where data can be pulled in larger quantities, etc?

You need to make use of the Record List To Excel action in order to export the data. This creates a worksheet in Excel with all of the data that is currently associated with a certain entity. After that uno online, you need to give the user the ability to download the Excel file that was generated.

Let's take one step further back.  What are you exporting?  Why are you exporting it?  How many rows?  How many pages?

Is exporting THAT going to be the best experience for your client?

For a faster Excel export in Appian:

-->Optimize Queries: Retrieve only necessary data.

-->Database Views: Use views for direct database export.

-->Record Lists: Use the "Record List to Excel" feature.

-->Review Export Strategy: Confirm if full exports are necessary or if they can be batched or scheduled.