2

According to this same question, the answer is pretty obvious: without .Net pooling on, the website has to re-connect to the database every time (every Postback time?).

However, there has to be other consequences, such as SQL memory leaks through over use of opening/closing the database without buffering?

With pooling turned OFF, does ASP.net have to recompile the ASPx/C files everytime? Plus reload all dlls?

If there are no direct and "dangerous" consequences, then I'd rather have a new connection each time and give the user better consistency of data directly from the database and not have to rely on buffers that could get corrupted. I just made that up - sorry, but really what are the real dangers?

Thank you

Community
  • 1
  • 1
Fandango68
  • 4,461
  • 4
  • 39
  • 74

1 Answers1

2

From the MSDN Connection Pooling

Connecting to a data source can be time consuming. To minimize the cost of opening connections, ADO.NET uses an optimization technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections. Connection pooling is handled differently for the .NET Framework data providers.

On your question " With pooling turned OFF, does ASP.net have to recompile the ASPx/C files everytime? Plus reload all dlls?" the answer is of cource not, the connection to the database have nothing to do with the compilation.

The pooling technique is transparent to your program. So also have nothing to do with SQL Memory leaks. You open and close your connection normally, and the server is handle the pooling.

Aristos
  • 66,005
  • 16
  • 114
  • 150
  • This also explained it well for me. http://www.codeproject.com/Articles/17768/ADO-NET-Connection-Pooling-at-a-Glance – Fandango68 Mar 16 '16 at 04:04