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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
