I'm doing a jxls report, my query returns only 6000 rows and it ran in less than 1 second in sql server but when I ran the report I got an OutofMemoryError (Java heap space).
After reding a bit of that, I have increased the amount of memory for the java machine (-Xmx3072m) but I still getting the error, sometimes, the error change to OutofMemoryError: GC (Garbage collection). It looks like something is wrong inside because 3GB of memory looks a lot for 6000 rows.
Those tests were done with ART 4.10 so I upgrade to 5.0 and I am still getting the error.
In order to avoid the error, I have limited the results set with a top 500 and it works smoothly in a couple of seconds but once I have increased to top 1000 the error returns.
Could you give me a hand please?
Regards!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Excel libraries in Java are expensive in memory consuming.
I've ART running with 24GB of RAM, and sometimes memory is exhausted by someone exporting a spreadsheet.
My personal believe is that this is not a ART problem, but the POI and jXLS fault (or "by default implementation").
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi there!
I'm doing a jxls report, my query returns only 6000 rows and it ran in less than 1 second in sql server but when I ran the report I got an OutofMemoryError (Java heap space).
After reding a bit of that, I have increased the amount of memory for the java machine (-Xmx3072m) but I still getting the error, sometimes, the error change to OutofMemoryError: GC (Garbage collection). It looks like something is wrong inside because 3GB of memory looks a lot for 6000 rows.
Those tests were done with ART 4.10 so I upgrade to 5.0 and I am still getting the error.
In order to avoid the error, I have limited the results set with a top 500 and it works smoothly in a couple of seconds but once I have increased to top 1000 the error returns.
Could you give me a hand please?
Regards!
Excel libraries in Java are expensive in memory consuming.
I've ART running with 24GB of RAM, and sometimes memory is exhausted by someone exporting a spreadsheet.
My personal believe is that this is not a ART problem, but the POI and jXLS fault (or "by default implementation").