SQL Server: One connection vs Connection Per Client

[Eli Nurman]

Hi When building a website, which method will increase performance, Using one connection in a global variable and using it to execute all queries or opening a connection for each user (Session)? Please advice.

[David Mujica]

Check this article out ... ADO.NET Connection Pooling at a Glance[^] It may help you understand what is going on with the web server and the database server. Good luck. :thumbsup:

[jschell]

Normally the second. But, again normally, there are far better reasons for doing that than performance.