RE: JAVA400-L Digest, Vol 4, Issue 47

Just an FYI...POI is notoriously slow when the file has many columns.
Addition of new rows is a fairly linear use of CPU but it's very
expensive for adding new columns...

In case your interested there is an open source version which uses POI &
a modified version of Scott's service program located at
http://www.sourceforge.net/projects/iseriestoexcel 


Thanks,
Tommy Holden


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
as400tech@xxxxxxxxxxx
Sent: Tuesday, February 21, 2006 11:23 AM
To: java400-l@xxxxxxxxxxxx
Subject: Re: JAVA400-L Digest, Vol 4, Issue 47

Thorbjorn,
Thanks for the reply. I finally managed to get it to at least do
something by keying it in like so:

SYSTEM "CRTJVAPGM 'poi-2.5.1-final-20040804.jar' OPTIMIZE(40)"

When it gets finished, I will be able to test my program and see if this
will help the preformance. 

Thanks,

Terry Anderson

> message: 3
> date: Tue, 21 Feb 2006 00:17:58 +0100
> from: Thorbj?rn Ravn Andersen  <thunderaxiom@xxxxxxxxx>
> subject: Re: Performance when using POI to create an excel workbook.
> 
> as400tech@xxxxxxxxxxx wrote:
> 
> >List,
> >I started this post on the Midrange-L list, but was told I may have
> >better luck finding an answer here.
> >
> >O.K., this is what is happening. I have modified Scott Klement?s
> >XLCRTDEMO program that creates an excel workbook from an RPG program
> >using the Jakarta POI java routines. This works great with the
exception
> >of the time it takes to create the workbook. From start to finish, it
is
> >taking about 30 minutes. It takes about 90 seconds to build the work
> >file and the rest of the time is being spent creating the workbook.
> >
> >It was suggested that I try to optimize the .jar file using the
> >following command.:
> >
> > SBMJOB CMD(QSH CMD('for jar in $(find /jakarta-poi-2.5.1/ -name
> > ''*.jar''); do system "CRTJVAPGM CLSF(''"$jar"'')
OPTIMIZE(40)";done')) 
> >
> >I was unable to get it to run as a submitted job, but I could get it
to
> >run interactively. I now get :
> >
> >find: 001-2187 The option db2_classes.jar is not valid.
> >  
> >
> This is the find command complaining. This might be because it somehow

> gets the "*.jar" expanded - hard to tell.
> 
> You might instead ask the invoking JAVA command to optimize to level
40, 
> just to see if it helps. This is not saved to disk, but it will give
you 
> a hint if it is worth the effort.
> 
> -- 
> Thorbj?rn
> 
> 
>