Re: RPG calling JAVA performance

Giuseppe,

This apparently only works if the TO file for CPYFRMIMPF already exists, 
which is not the case: we don't know in advance how may fields will be in 
the CSV, nor which data type they will be.

My current version supports this, but when the record count goes over 
1.000, it takes ages to generate.

Have you tried calling JExcelApi from RPG and compared the performance to 
POI?

Even if it goes only twice as fast, we could double the record count 
without suffering performance loss.

Thanks,

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




"Beppe Costagliola" <beppecosta@xxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
22/11/2004 14:12
Please respond to RPG programming on the AS400 / iSeries

 
        To:     "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
        cc: 
        Subject:        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