RE: Beyond RPG CGI -- WEB400

Brad,

Would you be willing to post a short explanation of DB/Connection Pooling?
Is it only for Web stuff or can I use it on stand alone Swing applications?

TIA,

Joel R. Cochran
Director of Internet Services
VamaNet.com
(800)480-8810
mailto:webmaster@vamanet.com


> -----Original Message-----
> From: Brad Stone [mailto:brad@bvstools.com]
> Sent: Friday, April 05, 2002 10:59 AM
> To: web400@midrange.com
> Subject: Re: [WEB400] Beyond RPG CGI
>
>
> Dan,
>
> Connection pooling will make a HUGE difference with your
> JDBC connections.  I would guestimate that you would see an
> increase of over 50% performance.  The connection is what
> takes the longest.
>
> Websphere has connection pooling built in, but if you're
> like me you like to roll your own.  I've got a connection
> pooling and database pooling objects.
>
> So, at startup I load all the db pools, then each db pool
> has it's own connection pool.
>
> Made a huge difference in my little apps that I mess around
> with.  And pooling, once understood, is really very simple.
> You don't need Websphere for it.
>
> Brad
> On Thu, 4 Apr 2002 15:32:34 -0700
>  "Eyers, Daniel" <daniel.eyers@honeywell.com> wrote:
> > That's sort of where we are... Having achieved a
> > "critical mass" of knowledge with our developers (who
> > have struggled
> > heroically with RPG v. Java), we are having trouble
> > keeping up with the demand we created.
> >
> > One of our next steps is getting the box tuned a little
> > better for web applications.  It tends to drag with use.
> > We may
> > have gotten to the point where JDBC starts to lose it's
> > appeal (in favor of native 400 connections).  However, we
> > are
> > not yet using connection pooling, so maybe that will
> > help....
> >
> > dan
> >
> >
> > -----Original Message-----
> > From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
> > Sent: Thursday, April 04, 2002 4:58 PM
> > To: 'web400@midrange.com'
> > Subject: RE: [WEB400] Beyond RPG CGI
> >
> >
> > This message is in MIME format. Since your mail reader
> > does not understand
> > this format, some or all of this message may not be
> > legible.
> > --
> > [ Picked text/plain from multipart/alternative ]
> > Amen....  I know I have been trying to sell these
> > capabilities to our
> > managers, and they finally gave me the freedom to write a
> > large intranet
> > web application... And they loved it...  It's fast, and
> > it handles indexing
> > through several million records in sub second response
> > times... And not only
> > that, I have been given more web projects...  They
> > actually prefer it on the
> > as/400, because they know the as/400 has such a nice
> > database, plus it's
> > reliable.....  I just had to show them what it could do..
> >
> > tim
> >
> > > -----Original Message-----
> > > From:     Jim Langston [SMTP:jlangston@celsinc.com]
> > > Sent:     Thursday, April 04, 2002 12:53 PM
> > > To:       'web400@midrange.com'
> > > Subject:  RE: [WEB400] Beyond RPG CGI
> > >
> > > Part of the problem, I think, is that CIOs and Managers
> > don't understand
> > > the
> > > AS/400 and what it's capable of.  They think of it as a
> > mainframe that's
> > > okay for business data and is programmed in some
> > obscure language called
> > > RPG, what, they playing Role Playing Games on these
> > things?
> > >
> > > Start letting CIOs and Managers know that, hey, the
> > AS/400 can also do C,
> > > C++, and now can do Linux, PERL, Java, etc... some of
> > the things they've
> > > heard about.  So they get a warm glowing feeling, if
> > all the RPG
> > > programmers
> > > drop off the face of the earth, they can get someone
> > out there to program
> > > in
> > > C, or Java, or PERL...
> > >
> > > I definitely agree, it is a problem of perception, not
> > reality.
> > >
> > > Regards,
> > >
> > > Jim Langston
> > >
> > > -----Original Message-----
> > > From: Jon Paris [mailto:Jon.Paris@Partner400.com]
> > > Sent: Thursday, April 04, 2002 10:23 AM
> > > To: web400@midrange.com
> > > Subject: [WEB400] Beyond RPG CGI
> > >
> > >
> > >  >> CIOs (and managers) who fail to understand that
> > will fail. period.
> > >
> > > <SNIP>
> > >
> > > The problem is one of perception - not reality.
> > >
> > > Jon Paris
> > > Partner400
> > > _______________________________________________
> > > This is the Web Enabling the AS400 / iSeries (WEB400)
> > mailing list
> > > To post a message email: WEB400@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> > > or email: WEB400-request@midrange.com
> > > Before posting, please take a moment to review the
> > archives
> > > at http://archive.midrange.com/web400.
> > _______________________________________________
> > This is the Web Enabling the AS400 / iSeries (WEB400)
> > mailing list
> > To post a message email: WEB400@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> > or email: WEB400-request@midrange.com
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/web400.
> > _______________________________________________
> > This is the Web Enabling the AS400 / iSeries (WEB400)
> > mailing list
> > To post a message email: WEB400@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> > or email: WEB400-request@midrange.com
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/web400.
> >
>
> Bradley V. Stone
> BVS.Tools
> www.bvstools.com
> _______________________________________________
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> or email: WEB400-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.
>