[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