RE: Improving Excel generation performance through calling Java

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> the RPG-Java interface is not optimized somehow.  I am religiously
> freeing
> local references, as the HSSFR4 service program does.  In fact, as a
> further test, I put the new_String(TempStr) and
> hssf_freeLocalRef(TempStr)
> back in my procedure, even though they aren't used anymore, and
> performance
> went back to what is was in the older java code and temporary storage
> jumped back up.

Can you share your hssf_freeLocalRef() code?  Maybe something not quite
right about that?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"When I was a boy of fourteen, my father was so ignorant I could hardly
stand to have the old man around.  But when I got to twenty-one, I was
astonished at how much he had learned in seven years."
        -- Mark Twain