Re: Speed issues? -- JAVA400-L

I think even though you caught the end, you hit the nail on the head.  I had
an idea that implementing a thin client with a server on the backend would
help things but it is out of my league to try and write a true client/server
implementation.  If they are Open Source solutions that may help me then I
have something else to research.

I have a few things to try now and I don't know what method will work best,
I'll probably need to implement a mixture of all.

Also, do all the below mentioned pooling tools work on an AS400 environment?

Robert



----- Original Message -----
From: "David Morris" <David.Morris@plumcreek.com>
To: <java400-l@midrange.com>
Sent: Tuesday, July 16, 2002 1:14 PM
Subject: Re: Speed issues?


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