Alex Rivera | Logout

POI performance

Asked 2010-03-23T08:54:43.173
23

I am using POI in my J2EE web application to generate a workbook. However, i find that POI takes around 3 mins to create a workbook with 25K rows(with around 15 columns each). Is this a POI performance issue , or is it justified to take that much of time? Are there other APIs known for better performance ?

java excel apache-poi
Edit
Report

1 Answer

14

I would be very surprised to see POI take that much time to generate such a file. I just generated a sheet with 30000 rows x 10 cells in about 18s (no formatting, to be fair). The cause might be one of the following:

  • POI logging might be turned on, as described here
  • you are running from swap memory
  • your VM available heap might be very low
answered 2010-03-23T09:42:13.267

Your Answer