A connection to a database is a resource intensive operation that typically comprises a few steps. A channel of communication between the application and the database should be established before the ...

Use profiler.<br><br>SQL leaves them open for a time for the connection pooling of course. -- View image here: http://episteme.arstechnica.com/infopop/emoticons/icon ...

The ability to open several connections to a database and distribute those connections to the next available request for data. On the Web, connection pooling is performed to improve performance.

I've got a fairly large legacy fat-client app that needs some performance improvements in its DB access since the powers that be have decided to relocate the SQL servers that the client talks to about ...