× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. July 2002

RE: Speed issues?

Establishing a Connection and data access are two different things, so I
think Connection Pooling would still be available though I'm not 100% sure.

Are you using the native type JDBC driver?  I use all SQL in my JDBC
programs.  That's what makes them portable to another database down the
road, so I only use the "com.ibm.as400.access.AS400JDBCDriver"


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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.