Re: Speed issues?

["Robert Upshall" <rupshall@xxxxxxxxxxx>]

Thats what I was wondering.  Is there a way to use connection pooling with
the 400 toolkit?  Or would I have to switch all my access from using the
toolkit to useing sql.

Robert


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


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