[freetds] Multiple Connection Pools
Shaun Craig
s.craig at andronics.com
Mon May 9 12:04:41 EDT 2005
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
>
>
More information about the FreeTDS
mailing list