search

rdicroce / jsfexporter

Lapis JSF Exporter
19 stars 17 forks source link

Datatable too big? #29

Open WurstCommander opened 10 years ago

WurstCommander commented 10 years ago

hello,

at first I would like to thank you for your work, the jsf exporter is great!

It works fine for me, but now I have a datatable with around 65k entries and the creation of the file isn't executed. Is there a limit for data which the exporter can handle?

rdicroce commented 10 years ago

The only limit I'm aware of is the amount of available heap space. There has to be enough to store an in-memory representation of the entire export. It's not ideal, but some file formats just can't be written to the browser row by row.

WurstCommander commented 10 years ago

I used the Excel-Exporter.

I changed from Xms2g -Xmx4g -XX:MaxPermSize=128m to Xms4g -Xmx6g -XX:MaxPermSize=256m and the max lines I can export are still around 45k. The primefaces exporter has the same limit, maybe JSF to excel just can't to more and I have to use the datalayer to create the exportfile :(

rdicroce commented 10 years ago

This exporter and the PF exporter both use the Apache POI library to generate Excel output. It's possible that you're hitting a limitation or bug in POI.

WurstCommander commented 10 years ago

Sorry for my late reply, it doesn't seem to be a bug with the POI. The data never "reaches" the POI lib, if the datatable is around 50k entities. If I find the time to do this,, I will provide a example JSF project.