I was wondering about something. For all of our SQL Server requests, we issue a connection string to get a handle to our database. Only on the first connection, that it will take one or two additional seconds. Then, on all other connections, it goes fast.
Would there be any optimization by only doing that at the startup of the application and then be able to use the handle whenever we need it without having to get a new handle from a connection for each request?