Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Opening Remote & Local Data Connection

Posted on 2016-08-24
2
Medium Priority
?
73 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 70

Accepted Solution

by:
Éric Moreau earned 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

772 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