Re: RPG calling JAVA performance

[Peter.Colpaert@xxxxxxxxxx]

Giuseppe,

I'm also struggling with the (non-)performance of POI called from RPGLE.

But my problem is that I use as input a flat file which contains CSV data.

This file was previously copied to the IFS with CPYTOSTMF, but a real XLS 
would be better.  So rather than modifying the program which generates the 
CSV, I opted for making a generic utility that accepts the CSV as input 
and generates an XLS in the IFS.  I had already done the same in a 
different program that accepts any file as input.

But just like Vincenzo said, after about 10.000 records the performance is 
really very very bad, so we are now looking for alternatives.

So I'm very interested in the "pure java" you mention, if I can modify it 
to parse the CSV instead of taking an SQL statement.

Can this be done, while of course preserving the performance?

Thanks,


Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Real developers never document.  If it was hard to write, it should be 
hard to understand.
-----


Subject: Re: RPG calling JAVA performance 
From: "Beppe Costagliola" <beppecosta@xxxxxxxx> 
Date: Fri, 1 Oct 2004 13:21:53 +0200 
List-archive: <http://archive.midrange.com/rpg400-l> 
List-help: <mailto:rpg400-l-request@xxxxxxxxxxxx?subject=help> 
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com> 
List-post: <mailto:rpg400-l@xxxxxxxxxxxx> 
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, 
<mailto:rpg400-l-request@xxxxxxxxxxxx?subject=subscribe> 
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, 
<mailto:rpg400-l-request@xxxxxxxxxxxx?subject=unsubscribe> 


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;')