Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Optimizing Memory Usage while Working with Big Files Having Large Datasets
Contents
[
Hide
]
When building a workbook with large data sets, or reading a big Microsoft Excel file, the total amount of RAM the process will consume is always a concern. There are measures which can be adopted to cope with the challenge. Aspose.Cells provides some relevant options and API calls to lower, reduce, and optimize memory use. It can also help the process work more efficiently and run faster.
Use MemorySetting.MEMORY_PREFERENCE option to optimize the memory used for cell data to decrease the overall memory cost. When building a large data set for cells, it can save a certain amount of memory compared to using the default setting MemorySetting.NORMAL.
Optimizing Memory
The following example shows how to optimize memory usage while working with large data in Aspose.Cells for Node.js via Java.
Caution
The default option, MemorySetting.NORMAL is applied for all versions. For some situations, such as building a workbook with a large data set for cells, the MemorySetting.MEMORY_PREFERENCE option may optimize memory use and decrease the memory cost for the application. However, this option may degrade performance in some special cases such as follows.
- Accessing Cells Randomly and Repeatedly: The most efficient sequence for accessing the cells collection is cell by cell in one row, and then row by row. Especially, if you access rows/cells by the enumerator acquired from Cells, RowCollection and Row, performance is maximized with MemorySetting.MEMORY_PREFERENCE.
- Inserting & Deleting Cells & Rows: Please note that if there are many insert/delete operations for cells/rows, the performance degradation will be notable for MemorySetting.MEMORY_PREFERENCE mode as compared to the MemorySetting.NORMAL mode.
- Operating on Different Cell Types: If most of the cells contain string values or formulas, the memory cost will be the same as MemorySetting.NORMAL mode, but if there are many empty cells, or cell values are numeric, boolean, and so on, the MemorySetting.MEMORY_PREFERENCE option will give better performance.