I moved the new_String procedure into the java routine, simply passing it a
varying string (defined as a byte[] in the java parameter list), and saw
another drastic jump in performance and a corresponding drop in temporary
storage used by the job. This is curious, but it seems to point out that
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.
It seems to indicate that bringing java objects into RPG should be
minimized.
From: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date: 03/22/2010 01:28 PM
Subject: Re: Improving Excel generation performance through calling Java
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
Hi Darren,
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.
That absolutely startles me. Were you doing garbage collection properly
in your RPG version?
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.
Why not pass a byte string to the create cell routine? Then you could
pass an RPG-style alphanumeric string directly to the Java routine. The
Java routine would use the byte[] to create the String object.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
