FreeTDS Development Group

[Shaun Craig <s.craig AT andronics.com>]

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
>