Re: RPG calling JAVA performance

Peter,

you can upload the CSV into a table (CPYFRMIMPF) and then generate the XLS
from it.

Giuseppe.

----- Original Message ----- 
From: <Peter.Colpaert@xxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, November 22, 2004 1:33 PM
Subject: Re: RPG calling JAVA performance


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