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.

We are exporting less data still taking 3043 ms peak average it will fail on real time data so what will be the best posible case to reduce time?

How much time does the same query take to execute using query entity?

Did you consider to create a view in the database with the exact structure as you need in the Excel, and then export this?

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.