Re: Improving Excel generation performance through calling Java

So far my results are, with running both ways twice, using the standard
HSSF api's from pure RPGLE it took 11 minutes. Coding the 4 steps to
create row in java, called from RPG, takes 5 minutes. It took around 650mb
temp storage originally, and now is about 450mb. This is for a 690,000
cell spreadsheet, or two tabs of 23,000 rows of 15 columns each.

This method still requires creating a java string object to pass to the
create cell routine, so there is still a memory leak in that step, but I
cannot think of a way around that issue.