RE: Speed issues?

["Joel R. Cochran" <jrc@xxxxxxxxxxxxx>]

Robert,

I wrote several Swing applications that use the Toolbox to connect to a
400's UDB (none that access RPG programs) and initially I had the same
problem.  What I found was that it really has a lot to do with the
horsepower of the 400 you are connecting to.  When I connect to our 73 CPW
170 the programs seem to crawl.  On the other hand, when I connect to our
1070 CPW 270 it is lightening fast.  I know this doesn't really answer your
question but I thought I would share my experiences.

One thing that might help, and you may be doing this already, is to only
create one Connection object and then pass it around to whatever other
objects need to connect to the database.  The initial call will still take
some time but subsequent database access will be much quicker.  If you need
an example of this I would be happy to post it.

Joel R. Cochran
Director of Internet Services
VamaNet.com
(800)480-8810
mailto:webmaster@vamanet.com


> -----Original Message-----
> From: Robert Upshall [mailto:rupshall@psasoft.com]
> Sent: Thursday, July 11, 2002 9:23 AM
> To: java400-l@midrange.com
> Subject: Speed issues?
>
>
> Hi,
>
> I have been creating a system that uses "AS400 Toolbox For Java".  The
> system is a GUI front-end runs on a pc and uses the toolbox connection
> classes to access DB2 files and RPG programs.  Can somebody
> tell anything I
> might want to try to speed up my connections?  Currently they
> seem to run
> allot slower that I expected.
>
> Thanks,
>
> Robert Upshall
> Professional Software of Amarillo
> (806) 358-8928
> rupshall@psasoft.com
>
>
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries /
> AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>