[MonetDB-users] best practices with connection pool

Fabian Groffen Fabian.Groffen at cwi.nl
Tue Sep 30 14:57:09 CEST 2008


On 29-09-2008 09:56:48 +0900, gashi gashi wrote:
>    >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.
>    ----------------------------------------------------------------------
> 
>    Would you let me know more detail?
>    Your meaning of "Beware that using >1 connection at the same
>    time..." is which case?
> 
>     Case 1. : 2 or more process try to connect at the same.
>     Case 2. : 1 process is connecting, and other process try to
>    connect.

Both.  In particular when both processes are executing queries.
Theoretically this work, of course.




More information about the users-list mailing list