Hi,All

I found this subject in the archives, and I am having the same problem.

----------------------------------------------------------------------

...

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.

----------------------------------------------------------------------

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.

I appreciate your kindly support.

gashi