RE: Speed issues?

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

On the faster machine the response time is outstanding, no problems there.
On the slower machine it probably was too slow for production work, and I do
think that most of that time was taken up in the DB connection.

Some things you might look into to enhacne performance might be Connection
Pooling and some SQL things like Prepared Statements and Callable
Statements.  I'm not doing either of these right now but I understand they
can help performance.

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:58 AM
> To: java400-l@midrange.com
> Subject: Re: Speed issues?
>
>
> 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.
> >
> >
>
>
>
> _______________________________________________
> 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.
>