Skip to main content
July 31, 2024
Question

Export Report to CSV - Loading bars + Slow load times

  • July 31, 2024
  • 8 replies
  • 0 views

Hello Appian Community!

We currently have the export to CSV enables on all of our reports. We did have our production environment go down as a user was confused and exported the same report 27 times which started a sync of those reports and took down our prod server for high memory usage.

What came out of this were some questions, is there anyway to show to the user that they have selected the export to csv button like a loading bar? Currently when a user selects this button it appears nothing is happening and then a document will pop-up after several minutes once completed. 

The next issue is we are experiencing some pretty slow load times. If we were to export a csv report in our UAT environment with 5000 lines we are seeing it take roughly 10 seconds. With that exact same report in production for 5000 lines we are seeing roughly 15 minutes. Is there any way for us to investigate this export feature to understand why we are seeing such slow load times? 

Thanks,

Jordan

8 replies

stefanhelzle0001
July 31, 2024

Can you tell us more about your app? E.g. do you use records? Do you use synced records? Do these "report" read data from database views?

Extensive loading times are a problem that needs to be solved in the database.

July 31, 2024

Hi Stefan,

We are using the showExportButton: true for our a!gridField() that uses a synced record for its data. 

stefanhelzle0001
July 31, 2024

Did you check the "Query Performance" tab in "Monitoring"?

https://docs.appian.com/suite/help/24.2/monitoring_view.html#query-performance