> Regarding ASP.NET, I'm of the school of thought that database > connections be created at function level; as in, created and destroyed > many many times (if necessary) throughout the page life-cycle. >
We do keep the connection "alive" during the page request. We were seeing too many calls to the db server "resetting" the connection. Keeping the connection "alive" during a page request (in httpContext.items and disposing it endRequest, transparently handled by our datalayer) resulted in a much better throughput of the website. // Ryan =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
