SQL Server and ASP.NET performance tips
| 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. |
|