Performance Testing

Aspose.Cells Product Family
1

Hi Team,


I am taking performance readings of aspose.cells.

Configuration and results are

1 Lac rows and 80 Cols. ===== Test Passed == -Xms512m -Xmx3G
2 Lac rows and 80 Cols. ===== Test Passed == -Xms512m -Xmx3G
3 Lac rows and 80 Cols. ===== Test Passed == -Xms512m -Xmx3G
4 Lac rows and 80 Cols. ===== Test Passed == -Xms512m -Xmx3G
5 Lac rows and 80 Cols. ===== Test Passed == -Xms512m -Xmx3G

6 Lac rows and 80 Cols. ===== Test Failed == -Xms512m -Xmx3G
6 Lac rows and 80 Cols. ===== Test Failed == -Xms512m -Xmx4G
6 Lac rows and 80 Cols. ===== Test Failed == -Xms512m -Xmx5G

Why it is not getting passed for excel with 6 Lac rows?

Thanks & Regards,
Kapil Jaiswal
2

Hi Kapil,

Thanks for your posting and using Aspose.Cells.

Please provide us your output excel file which is created by one of your test like

1 Lac rows and 80 Cols. ===== Test Passed == -Xms512m -Xmx3G

We will then analyze why you are getting failure on increasing the number of rows. Please note, Aspose.Cells does not have problem dealing with cells A1:XFD1048576, these are 16384x1048676 cells. These are almost 17.2 billion cells. It only depends on available memory and CPU processing speed.