Re: Speed issues?

["Robert Upshall" <rupshall@xxxxxxxxxxx>]

That is probably the only speed enhancement I currently have made, I do pass
around the same connection object but that's about all I think I am doing.
I too have noticed faster running on faster machines.

Did you find it to be to slow?

Robert

----- Original Message -----
From: "Joel R. Cochran" <jrc@masi-brac.com>
To: <java400-l@midrange.com>
Sent: Thursday, July 11, 2002 8:47 AM
Subject: RE: Speed issues?


> 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.
> >
> _______________________________________________
> 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.
>
>