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



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.