I have a file which has around 50 tabs and in all 9 lakh records. Can I display the file on aspose web using pagination? Will it have any impact on performance? How much memory would be ideally required?
Do we have some benchmark around the same
@shahsidd1
If you only render one paginated page at a time, it will not have a significant impact on performance. The amount of memory occupied depends on your files. When your file contains a large amount of scattered data, it will take up a lot of memory after loading the file, as these data cannot reference the same cache.
Moreover, we think you can try to use MemorySetting.MEMORY_PREFERENCE option to optimize memory used for cells data to decrease the overall memory cost. When building large data set for cells, it can save a certain amount of memory. See the document for your reference.
https://docs.aspose.com/cells/java/optimizing-memory-usage-while-working-with-big-files-having-large-datasets/
Additionally, you may try using LightCells APIs, which is an efficient (even driven) mode to read and write large Excel files with huge list of data or contents in the worksheets. The LightCells API is useful for creating huge Excel spreadsheets and you would get better performance and efficiency. See the document with examples for your reference.
https://docs.aspose.com/cells/java/using-lightcells-api/
Hope, this helps a bit.
Thank you for a quick turnaround. Will try them and let you know my findings