Hi All,
I am facing an issue while exporting the data of 40k+ to CSV. Here is the implementation detail
Above functionality works well if I export small amount of data. But when I tries to export the huge data say around 40 to 50 thousand records, system is generating the error as "System.OutOfMem oryException"
To resolve this issue, I tried to use string builder but even after that issue still remains as it is. Can anybody let me know the solution for this? How to tackle such issues?
Regards
Amol Lokhande
I am facing an issue while exporting the data of 40k+ to CSV. Here is the implementation detail
- Fetch the data from database
- Create the comma seperated list and store that into string variable
- Once the entire data is converted into comma seperated list write that string variable with data in it (comma seperated list) back to the browser using Reponse.write
Above functionality works well if I export small amount of data. But when I tries to export the huge data say around 40 to 50 thousand records, system is generating the error as "System.OutOfMem oryException"
To resolve this issue, I tried to use string builder but even after that issue still remains as it is. Can anybody let me know the solution for this? How to tackle such issues?
Regards
Amol Lokhande