![]() |
|
Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Re^2: Using a single database handle or multiple handlesby mpeppler (Vicar) |
on Oct 24, 2012 at 12:16 UTC ( #1000619=note: print w/replies, xml ) | Need Help?? |
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
|
|