locked
Out of Memory Exception RRS feed

  • Question

  • User-693557827 posted
    You cannot vote on your own postI have developed an web application and hosted in IIS server. ~100 reports is exporting data from sql to excel file. The data contains 60+ columns and 3,00000 (+-) records. My web server is having 8 GB ram . After saving the  ~5-6 excel files, i am getting the out of memory exception. How to clean up the memory after saving the each excel file in web server?
    Thursday, May 22, 2014 11:55 PM

Answers

  • User-1454326058 posted

    Hi vasanthmnr,

    To reclaim all memory that is inaccessible, we could use this code below:

    GC.Collect();

     More information, please refer to:

    # GC.Collect Method

    http://msdn.microsoft.com/en-us/library/xe0c2357(v=vs.110).aspx

    Based on your reply, you are using the third part tool, it is not supported here. I suggest that you should post to the corresponding site for efficient response.

    Thanks

    Best Regards

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 26, 2014 5:01 AM

All replies

  • User1173053962 posted

    How are you exporting data do Excel?

    Do you use any kind of third-party library?

    Friday, May 23, 2014 2:30 AM
  • User-693557827 posted

    I am using third party tool for exporting records to excel  (Aspose)

    Friday, May 23, 2014 6:47 AM
  • User-1454326058 posted

    Hi vasanthmnr,

    To reclaim all memory that is inaccessible, we could use this code below:

    GC.Collect();

     More information, please refer to:

    # GC.Collect Method

    http://msdn.microsoft.com/en-us/library/xe0c2357(v=vs.110).aspx

    Based on your reply, you are using the third part tool, it is not supported here. I suggest that you should post to the corresponding site for efficient response.

    Thanks

    Best Regards

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 26, 2014 5:01 AM