You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by AM...@aol.com on 2002/06/28 16:43:56 UTC
connection pooling strategy
Hi All
I am a regular reader of this mailing list now and I quite often read about
connection pooling. I sort of understand what it is and I have read it in
many books. I just wanted to know what real benefits does it actually
provide? My home tomcat server runs with a MS Access database conected to it
and when i create the ODBC datasource it gives you the option to connection
pool. I tried it but i could not see any real improvements? So my question is
in what type of environment does one really need to invest the time to design
a connection pool strategy for? and if you have a MS Access database then is
it better to write your own connection pool or use MS Access connection pool?
Do other databses come with connection pools?
Thanxs in advance
Regards
Amran
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: connection pooling strategy
Posted by Anthony Geoghegan <an...@eircom.net>.
The M$ ACCESS ODBC driver is a queued single thread driver so no amount of
connection pool is going to make a whiff of difference. But because it is
queued, if the concurrent queued connections exceed 10 or so it is notorious
for failing.
This is the main reason I find MYSQL a much better low cost option.
Best Regards,
Anthony Geoghegan.
J2EE & Oracle Consultant.
----- Original Message -----
From: "Charles Baker" <ra...@yahoo.com>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Friday, June 28, 2002 5:40 PM
Subject: Re: connection pooling strategy
>
> --- AMRAN121@aol.com wrote:
> > Hi All
> >
> > I am a regular reader of this mailing list now and I
> > quite often read about
> > connection pooling. I sort of understand what it is
> > and I have read it in
> > many books. I just wanted to know what real benefits
> > does it actually
> > provide? My home tomcat server runs with a MS Access
> > database conected to it
>
> There in lies your problem, MS Access. To see the
> benefit you need to use a real database. Even MS SQL
> Server will do :-) though I use either PostgreSQL or
> MySQL for my own stuff and at my fulltime job we use
> Sybase. Most other folks I correspond with use Oracle.
> Despite some of Microsoft's counter claims, I really
> don't think Access was ever meant to be a multi user
> database.
>
> See
>
> http://www.macromedia.com/v1/handlers/index.cfm?ID=1540&Method=Full
>
> There is a link on that page which goes to a Microsoft
> Counter claim. However, in a previous life I worked at
> a university helpdesk. We had our own homegrown Access
> based trouble ticketing system. When we tried to
> extend it to other depts via the lan and the web we
> got flaky results, mysterious locks, etc.
>
>
>
> =====
> rascharles@yahoo.com
> Hacking is a "Good Thing!"
> See http://www.tuxedo.org/~esr/faqs/hacker-howto.html
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: connection pooling strategy
Posted by Charles Baker <ra...@yahoo.com>.
--- AMRAN121@aol.com wrote:
> Hi All
>
> I am a regular reader of this mailing list now and I
> quite often read about
> connection pooling. I sort of understand what it is
> and I have read it in
> many books. I just wanted to know what real benefits
> does it actually
> provide? My home tomcat server runs with a MS Access
> database conected to it
There in lies your problem, MS Access. To see the
benefit you need to use a real database. Even MS SQL
Server will do :-) though I use either PostgreSQL or
MySQL for my own stuff and at my fulltime job we use
Sybase. Most other folks I correspond with use Oracle.
Despite some of Microsoft's counter claims, I really
don't think Access was ever meant to be a multi user
database.
See
http://www.macromedia.com/v1/handlers/index.cfm?ID=1540&Method=Full
There is a link on that page which goes to a Microsoft
Counter claim. However, in a previous life I worked at
a university helpdesk. We had our own homegrown Access
based trouble ticketing system. When we tried to
extend it to other depts via the lan and the web we
got flaky results, mysterious locks, etc.
=====
rascharles@yahoo.com
Hacking is a "Good Thing!"
See http://www.tuxedo.org/~esr/faqs/hacker-howto.html
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: connection pooling strategy
Posted by John Gregg <jo...@techarch.com>.
I haven't done any tests lately, but once upon a time establishing a db
connection was an expensive operation. It was slow enough that you didn't
want users sitting there waiting unnecessarily every time they hit a web
page. A connection pool was the solution-- reuse the same open connection
over and over. I coulnd't tell you anything about Access and pools. Create
a test with a loop that opens and closes a db connection 10 or 100 or 1000
times and look at the average time.
john
-----Original Message-----
From:
tomcat-user-return-24387-john.gregg=techarch.com@jakarta.apache.org
[mailto:tomcat-user-return-24387-john.gregg=techarch.com@jakarta.apache.
org]On Behalf Of AMRAN121@aol.com
Sent: Friday, June 28, 2002 9:44 AM
To: tomcat-user@jakarta.apache.org
Subject: connection pooling strategy
Hi All
I am a regular reader of this mailing list now and I quite often read about
connection pooling. I sort of understand what it is and I have read it in
many books. I just wanted to know what real benefits does it actually
provide? My home tomcat server runs with a MS Access database conected to it
and when i create the ODBC datasource it gives you the option to connection
pool. I tried it but i could not see any real improvements? So my question
is
in what type of environment does one really need to invest the time to
design
a connection pool strategy for? and if you have a MS Access database then is
it better to write your own connection pool or use MS Access connection
pool?
Do other databses come with connection pools?
Thanxs in advance
Regards
Amran
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>