Hi,
We are using Export SQL to Excel smart service which will have max of 5 lacs rows in excel.It will be stored in temporary folder and the link will be sent to the user as email.The approximate size of the file is around 60 - 70 MB.Because of the size the server storage is getting filled and getting IOException (Not Enough Space). Could anyone please suggest me any alternate option to achieve this without reducing number of data?
Discussion posts and replies are publicly visible
These are very large files to be storing long-term on the server. Could you remove the export functionality and just allow the data to be viewed using Appian functionality?
Otherwise, could you have an automated process delete these files after a set period of time?
it is not recommended to pull the data with such huge load and this will impact performance. My thoughts are like as you are sending the links to the documents when u delete timely if the user at later point of time needs to check the documents he might go through the old link again and will not find the document. Please try the suggestion given by ashwin, as small chunks of data will not result bad performance. Can you breif your requirement here so that we will try to give the possible solutions with the best practices?