[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 75
  • Last Modified:

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.
0
Bob Schneider
Asked:
Bob Schneider
1 Solution
 
É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

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now