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
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?