jsfexporter
jsfexporter copied to clipboard
rdicroce
Datatable too big?
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?
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.
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 :(
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.
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.