Performance on export as XLS

I use Aspose Cells 1.1.1.1 for Japser Report 3.7.6

I made a benshmart on export execution for Jasper report. Here is the data

500 records : export Xls Aspose 2.2s / export Xls POI 1.6s

1600 records : export Xls Aspose 8.2s / export Xls POI 2.5s

5000 records : export Xls Aspose 71.3s / export Xls POI 6s

10 000 records : export Xls Aspose 288.8s / export Xls POI 9.5s

More this is data more the differences are.

Is there some ways or pratices to improve the time generation ?


I add also multi processes tests we've made

Fill report (Jasper) Export XLS Export XLS Aspose

1 process 13600 ms 4887 ms 43760 ms

2 processes 15500 ms 5500 ms 108 000 ms

3 processes 18200 ms 6600 ms 143 500 ms

Multi process does not impact to much on Jasper fill report but in Excel generation is seems the is a point of contention.


Anthony

Dear Anthony,



Can you please post both of codes which you used for testing Aspose.Cells and POI as well as the sample input files? It will be helpful for us to tune up Aspose.Cells and also, if possible, we will be able to recommend best practices to get best performance.

I am going to make a sample with your sample database as soon as possible. Next week probably.

Anthony

I was allowed to give you our report prototye (field real name and data access will be mocked).
Tomorrow

Anthony

Here is the project with JRXML jasper report file.
The main class tu use is "ProcessReportMock"
This class wait some parameters :
example
C:…\Jasper\SampleHsqlJavaProcess<br>xls_aspose


For “Poi” it is “xls_poi”. etc.
The code can be used as multi process or multi threading test.

I also noticed problems on fields formating un Excel. Dates, currency does not work and when in Excel (2007) you check the cell format (right click on a cell in Excel -> format cell) the format set in Jasper report is not taken in count (when I put for example number, or currency I have General format).

Anthony

Has some investigations have bean made ?

Hi,

Thanks for your patience.

I will let you know once I will get an update. This issue is logged as CELLSJSP-24672.

Hi,

Please try Aspose.Cells for JasperReports v2.0.1.1, we have fixed issue regarding Performance.

Kindly try it and let us know if it works fine now.

Thank you.

Thanks. I’ll test that next week as I have to make some new reports. I’ll tell you on performances.

Hello

I tested you new version today and performance of file generation are really better.
I give you my figures.

POI
------
Sheet 1 250rows 7columns
Sheet 2 4000rows 33columns
Sheet 3 4000rows 23columns
Sheet 4 4000rows 23columns
Sheet 5 7rows 4columns
12257rows
fillReportTime 54084
exportReportTime POI 29458ms

ASPOSE
-------------
Sheet 1 250rows 7columns
Sheet 2 4000rows 33columns
Sheet 3 4000rows 23columns
Sheet 4 4000rows 23columns
Sheet 5 7rows 4columns
12257rows
fillReportTime 54735
openWorkbook: 47
createSheet: 0
createSheet: 0
createSheet: 0
createSheet: 0
createSheet: 0
closeWorkbook: 657
ACXlsExporter: 39468
colordifftime: 6248
blankcelltime: 5285
borderstyle: 360
initCreateCell: 359
createTextCell: 5197
exportText: 24492
createMergeCell: 0
createMergeRegion: 94
exportReportTime Aspose 39447ms


For my tests
my reports have only data. There is no chart because I think it is
complicated to compare an Excel image output (POI) with a real Excel
graphic (Aspose).
JVM is 1024m
Computer is my own PC (P4 with 3GO)

POI
------
Sheet 1 500rows 7columns
Sheet 2 8000rows 33columns
Sheet 3 8000rows 23columns
Sheet 4 8000rows 23columns
Sheet 5 7rows 4columns
24507rows
fillReportTime 103374
exportReportTime POI 56800

Aspose

---------------

Sheet 1 500rows 7columns

Sheet 2 8000rows 33columns

Sheet 3 8000rows 23columns

Sheet 4 8000rows 23columns

Sheet 5 7rows 4columns

24507rows

fillReportTime 115820

openWorkbook: 79

createSheet: 0

createSheet: 0

createSheet: 0

createSheet: 0

createSheet: 0

closeWorkbook: 1295

ACXlsExporter: 76370

colordifftime: 15247

blankcelltime: 11270

borderstyle: 941

initCreateCell: 745

createTextCell: 10047

exportText: 48034

createMergeCell: 0

createMergeRegion: 236

exportReportTime Aspose 76321

Hi,

Thanks for your valuable feedback.

Regards,

No problem. I am glad to contribute.

One last test in same condition than before (JVM, computer…)

POI

Sheet 1 2000rows 7columns
Sheet 2 14000rows 33columns
Sheet 3 14000rows 23columns
Sheet 4 14000rows 23columns
Sheet 5 7rows 4columns
44007rows
fillReportTime 182348
exportReportTime POI 103305

Aspose
-----------
Sheet 1 2000rows 7columns
Sheet 2 14000rows 33columns
Sheet 3 14000rows 23columns
Sheet 4 14000rows 23columns
Sheet 5 7rows 4columns
44007rows
fillReportTime 181509
openWorkbook: 109
createSheet: 0
createSheet: 0
createSheet: 0
createSheet: 0
createSheet: 0
closeWorkbook: 1875
ACXlsExporter: 131739
colordifftime: 21131
blankcelltime: 17901
borderstyle: 1845
initCreateCell: 1454
createTextCell: 16186
exportText: 84839
createMergeCell: 0
createMergeRegion: 423
exportReportTime Aspose 131831

I think your new version bring really some improvement in export generation whereas it stays slower than POI when there are a lot of rows… It’s interesting.

Anthony SERFATI
Java EE Technical Expert

Hi,

We have improved the performance of our product further. Please try the attached version. And, we will continue to improve it in the future. Thank you for using our product and give us your feedback.


The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan