Skip to Content.
Sympa Menu

freetds - Re: [freetds] Multiple Connection Pools

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Shaun Craig <s.craig AT andronics.com>
  • To: brian AT bruns.com, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: Re: [freetds] Multiple Connection Pools
  • Date: Mon, 09 May 2005 17:04:41 +0100

Brian,

Heres my scenario.

Database1: on average will get approx 100'000 Query/Insert statements a day
Database2: will only get approx 200 Query/Insert statements a day

in pool.conf I have database = Database1, min conn = 2, max conn = 3

if in my Database2 code i use tablename Database2 will i lose all my connections to Database1 or just a single one? I could afford to lose one for a few seconds. Also when i exit my Database2 code will the connection pool open another permanent connection to Database1?

Thanks for you help, unfortunately my work day has finished now.

Shaun.


Brian Bruns wrote:

A connection pool can query multiple databases on one server just like
you would without the connection pool, use the dbname..tablename
notation.

The database name in the pool.conf file is the database which the
connection will "use" upon first connection. You should not do things
like "use database2" when running through the pool or things will go
horribly wrong. I have a way to fix this but currently lack the time
to do it.

On 5/9/05, Shaun Craig <s.craig AT andronics.com> wrote:

Can a connection pool query multiple databases? If so how do you set
this up in pool.conf, as I know it you have to give a database name in
this file, how can you add more databases?

Shaun.

Shaun Craig wrote:


Hi

Is it possible to have multiple connection pools running and if so do
you leave them on port 5000 or do you have to split them up?

Is there any dangers with multiple connection pools, etc, any info
would be great

Thanks,
Shaun.

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page