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
In Section
Seekers of Perl Wisdom