Opening Remote & Local Data Connection

Is it better (ie: more efficient) to open a data connection on your local machine and leave it open while the software is running (ie: race management software while timing a race) or continuing to open and close it as it is needed if it is needed fairly frequently?  

Same question for a remote connection.

I am using sql server 2012 express locally and web version remotely and the web site that houses these results will be getting significant traffic while the results are being processed.

I am using a vb6 application.
Bob SchneiderCo-OwnerAsked:
Who is Participating?
 
Éric MoreauSenior .Net ConsultantCommented:
Local or remote, it would be more efficient to keep the connection open if you don't have thousands of simultaneous users (connections)
0
 
Bob SchneiderCo-OwnerAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.