Re: RPG calling JAVA performance

Vincenzo,

you should consider using a "pure java" that allows to create large xlsup to
65,000 rows in a few minutes. I recently shared an utility to create xls
with POI or JExcelApi and you can download it (sources incuded) from
mcpressonline.

Giuseppe.

----- Original Message ----- 
From: "Vincenzo Amoruso" <vincenzo.amoruso@xxxxxxxxxx>
To: "Mailing LIst rpg400" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, October 01, 2004 10:50 AM
Subject: RPG calling JAVA performance


> Hi!
>
> I'm trying to improve the performance
> of a RPG programm that call Jakarta POI java classes to
> generate an excel file!
>
> I've already used OPTIMIZE(40) in CRTJVAPGM for POI-2.5.0.jar,
> but i have not seen some significative result,
> and after about 10000 rows written in excel work file, the performance
> are lower.
> Thanks in advance!
> Regards
>
> Vincenzo!
>
> P.S.:
> I've tried using environment variable! as follows :
>
> ADDENVVAR  ENVVAR(CLASSPATH)
> VALUE('/JAVA/lib/POI-2.5.0.jar:/QIBM/ProdData/Java400/jt400ntv.jar')
> ADDENVVAR  ENVVAR(QIBM_MULTI_THREADED) VALUE(Y)
> ADDENVVAR  ENVVAR(JAVA_COMPILER) VALUE(jitc_de)
> ADDENVVAR  ENVVAR(QIBM_RPG_JAVA_PROPERTIES)
>
VALUE('-Xms512M;-Xms99M;-Djava.version=1.3;-Dos400.stderr=file:/JAVA/lib/tem
p.out;-Djava.compiler=jitc_de;')
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (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.
>