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
Discussion posts and replies are publicly visible
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.
Hi Stefan,
We are using the showExportButton: true for our a!gridField() that uses a synced record for its data.
Did you check the "Query Performance" tab in "Monitoring"?
https://docs.appian.com/suite/help/24.2/monitoring_view.html#query-performance
If you are using a sync record, then ideally it should not take much time. How many records (~approx) getting exported?
The record only had 5000 rows being exported... so unsure why there is a discrepancy between our two environments when prod has more resources... I think the main issue is that there is no loading bar when trying to export a document to csv.
15 minutes for 5000 rows is not acceptable. You need to fix this first. I suggest to get someone involved with more experience.
Tried out the Query performance tab and i am not seeing the exports even hitting the system... any other ideas?
I suggest to investigate overall query times on that environment.
Did you consider to open a support case?