http://qs321.pair.com?node_id=1000619


in reply to Re: Using a single database handle or multiple handles
in thread Using a single database handle or multiple handles

Connecting to a modern Sybase server can cost between 100 to 300ms, depending on the amount of stuff that each connection needs to set up (e.g. if there are a lot of roles associated with the login being used, then this will take additional time).

It also puts a fairly heavy load on the server (we had systems with > 200k new connections per day which were showing very serious performance issues).

So I would always strive to limit the number of connections that you create, both for speed, and for load on the server.

Michael

  • Comment on Re^2: Using a single database handle or multiple handles