[freetds] Multiple Connection Pools
s.craig at andronics.com
Mon May 9 12:04:41 EDT 2005
Heres my scenario.
Database1: on average will get approx 100'000 Query/Insert statements
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.
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
>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 Craig wrote:
>>>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
>>>FreeTDS mailing list
>>>FreeTDS at lists.ibiblio.org
>>FreeTDS mailing list
>>FreeTDS at lists.ibiblio.org
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
More information about the FreeTDS