Re: Speed issues?

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Robert,

For some reason I only caught the tail end of this so I may not
understand the
speed issue, but it sounds like you have a GUI (swing?) thick client
that is not
performing well. One thing that can help performance is pooling of
objects and
connections. If you don't have a server component, it is going to be
difficult
to efficiently pool resources and scalability will likely be an issue.

There are all kinds of schemes and tools you can use to pool or cache
resources
but they work best when you have a common access point. I have used the

Apache Commons pooling and DBCP support and they work well on the
iSeries.
If you decide to use these be aware that they are not well documented
and
that it is easy to end up in a never ending wait. Two other open source
projects
that provide pooling implementations are Poolman and Tyrex. These last
two
seem to be losing momentum where the Commons projects are immature but

gaining momentum.

David Morris


>>> rupshall@psasoft.com 07/11/02 08:18AM >>>
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>

> 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
> > >
> > >
> > > > -----Original Message-----
> > > > From: Robert Upshall [mailto:rupshall@psasoft.com]
> > > >
> > > > 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