[Monetdb-developers] best practices with connection pool

Fabian Groffen Fabian.Groffen at cwi.nl
Tue May 27 17:06:13 CEST 2008


On 27-05-2008 16:41:02 +0200, Stefan de Konink wrote:
> What is currently the best practice of connecting to MonetDB5/SQL? Is 
> there much overhead in the connection phase (thus: cache the connection) 
> or can a developer just reconnect each time the database connection is 
> required without much overhead?
> 
> The target platform is extremely demanding in requests and memory, so I 
> would like to design it good from the start.

Then go for connection pooling.  Logging in requires a handshake, which
is expensive on large scale.  Beware that using >1 connection at the
same time to an SQL server is a challenge that is only minimally tested.
My practical experiences with that boils down to signal 11.




More information about the developers-list mailing list