Memory not getting cleared for a long time ( Over three hours)

Aspose.Cells Product Family
1

Hi,

We use Aspose cells for java version 7.6.1 in our project. We process big excel reports with it involving a lot of calculations.Recently we had a few Out of memory issues.On analysis with a profiler we found that millions of instances of com.aspose.cells.Cell lived in memory lond after the report generation process was over ( we found this time to be almost 3 hours before the memory started getting cleared up)

My question is has anyone faced this issue earlier . Can anything be done to clear up memory earlier ( provide some kind of fix) .

Please find attached the screenshot of the profiling view showing the numerous objects.

Thanks

Abhijit

2

Hi,


Since the release of Aspose.Cells 8.0.0 we provide memory usage options. In later versions we also enhanced the memory usage and performance. So, while working with big Excel Files or having large datasets, you may utilize the options, please see the document for your reference:
http://www.aspose.com/docs/display/cellsjava/Optimizing+Memory+Usage+while+Working+with+Big+Files+having+Large+Datasets

We recommend you to kindly try our latest version/fix: Aspose.Cells for Java 8.1.2

If you still find the issue, kindly do create a sample JAVA program (runnable) with your template files if you have any, we will check it soon.

Thank you.