[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-developers
Subject: Re: [Monetdb-developers] best practices with connection pool
From: Fabian Groffen <Fabian.Groffen () cwi ! nl>
Date: 2008-05-27 15:06:13
Message-ID: 20080527150612.GD28843 () cwi ! nl
[Download RAW message or body]
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.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-developers mailing list
Monetdb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic