No such thing as a small change | |
PerlMonks |
comment on |
( [id://3333]=superdoc: 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 reply to Re^2: Using a single database handle or multiple handles
by mpeppler
|
|