Solved

Opening Remote & Local Data Connection

Posted on 2016-08-24
2
51 Views
Last Modified: 2016-08-24
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
Comment
Question by:Bob Schneider
2 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 41769188
Local or remote, it would be more efficient to keep the connection open if you don't have thousands of simultaneous users (connections)
0
 

Author Closing Comment

by:Bob Schneider
ID: 41769193
Thank you!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now