Hi Everyone,
I have a requirement where in need to fetch more than 20K records from the database and then store it in Excel file,
As of now we are querying all the data once and writing it into a single excel file, which is taking more than 10-15 mins.
Can anyone suggest how we can break this into multiple excel file using the process model i,e if there are 100 records in the databse then we should be able to get 10 excel file with 10-10 records in each file.
Discussion posts and replies are publicly visible
Hi @gauravs0002 I agree with the points highlighted by Mike Cichy, 20K records are not that huge, and hence Appian should be able to export it in less amount of time.
I have couple of quick questions, to understand why it's taking that long for you to export the Data into excel.
Also it would be worth having a look into your Server configuration, because i have seen some cases where the server configuration was low and hence while performing any major job, server used to perform slower than expected.
Also, i would recommend to monitor the SQL Active Sessions, while performing this operation, just to make sure that, some other jobs / sessions are not active (as part of some other process) when you have started the export of data into Excel.
Hope this will help you in debugging and resolving the issue.
True.
If it is the view that is fetching the data then you can make it faster by providing index to the columns. That did help me.
Thank You!