SQL Server and ASP.NET performance tips

Home >> Dot Net Interview Questions >> Asp.net Basic Questions

Posted on June 22nd , 2009 by Admin

ALways use same connection string to get advantage of Connection pooling.Becuase connection polling is not used for new connection.

Always close user-defined transactions before closing a connection.

Close your connection as soon as you are done using it.

Do leave a connection open if it is not used.

Always drop temporary objects before closing a connection.

Open connection when on need not before the need.