Click here to Skip to main content
15,499,802 members
Home / Discussions / Database
   

Database

 
GeneralRe: Connection string for database on another comouter Pin
Wendelius3-Apr-11 6:57
mveWendelius3-Apr-11 6:57 
GeneralRe: Connection string for database on another comouter Pin
wjbjnr3-Apr-11 8:01
Memberwjbjnr3-Apr-11 8:01 
GeneralRe: Connection string for database on another comouter Pin
Wendelius3-Apr-11 8:15
mveWendelius3-Apr-11 8:15 
GeneralRe: Connection string for database on another comouter Pin
wjbjnr3-Apr-11 8:43
Memberwjbjnr3-Apr-11 8:43 
GeneralRe: Connection string for database on another comouter Pin
Wendelius3-Apr-11 8:53
mveWendelius3-Apr-11 8:53 
GeneralRe: Connection string for database on another comouter Pin
wjbjnr3-Apr-11 9:22
Memberwjbjnr3-Apr-11 9:22 
GeneralRe: Connection string for database on another comouter Pin
Wendelius3-Apr-11 10:33
mveWendelius3-Apr-11 10:33 
QuestionSQL Server Query Transportation Time Based on Latency and Internet Download Speed Pin
T21021-Apr-11 4:58
MemberT21021-Apr-11 4:58 
I had asked this question elsewhere and was advised to ask here instead.

I am wondering if anyone knows how internet connection latency and download speed affect query execution time in SQL Server Management Studio. Is that product similar to using a Data Reader instead of a Data Adapter? Is there a flag I can set to make it more like a Data Adapter? I am trying to get better performance on a remote office, especially since Disaster Recovery can be better handled from the headquarters.

I ran a test in SQL Server Management against the same database across the country. One internet connection had 4x the download speed according to speedtest.net, but a larger latency in ms. The difference is that one connection was a slow ethernet connection and the other a faster wireless connection. Same locations, multiple tests with similar results.

Somewhat surprisingly, the connection with the faster download speed took 50% longer to return a recordset in the 5-20 MB range. Is this because querying in SQL Server Management Studio is similar to executing a query with a Data Reader instead of a DataAdapter? If not, what is the issue?
AnswerRe: SQL Server Query Transportation Time Based on Latency and Internet Download Speed Pin
Wendelius1-Apr-11 7:42
mveWendelius1-Apr-11 7:42 
GeneralRe: SQL Server Query Transportation Time Based on Latency and Internet Download Speed Pin
T21021-Apr-11 17:04
MemberT21021-Apr-11 17:04 
GeneralRe: SQL Server Query Transportation Time Based on Latency and Internet Download Speed Pin
Wendelius1-Apr-11 21:43
mveWendelius1-Apr-11 21:43 
Questioninvalid parameter value on CreateSubscription Pin
run4ever_771-Apr-11 3:40
Memberrun4ever_771-Apr-11 3:40 
QuestionHarmless joke or mean prank Pin
shelbypowell1-Apr-11 2:14
Membershelbypowell1-Apr-11 2:14 
QuestionSelecting from an XML datatype into a table Pin
Mel Padden1-Apr-11 0:47
MemberMel Padden1-Apr-11 0:47 
AnswerRe: Selecting from an XML datatype into a table Pin
Mel Padden1-Apr-11 1:01
MemberMel Padden1-Apr-11 1:01 
QuestionSQL question Pin
loyal ginger31-Mar-11 9:14
Memberloyal ginger31-Mar-11 9:14 
QuestionRe: SQL question Pin
Jörgen Andersson31-Mar-11 9:45
professionalJörgen Andersson31-Mar-11 9:45 
GeneralRe: SQL question Pin
loyal ginger31-Mar-11 10:06
Memberloyal ginger31-Mar-11 10:06 
GeneralRe: SQL question [modified] Pin
Jörgen Andersson31-Mar-11 10:38
professionalJörgen Andersson31-Mar-11 10:38 
GeneralRe: SQL question Pin
loyal ginger31-Mar-11 11:16
Memberloyal ginger31-Mar-11 11:16 
AnswerRe: SQL question Pin
Jörgen Andersson31-Mar-11 11:28
professionalJörgen Andersson31-Mar-11 11:28 
GeneralRe: SQL question Pin
loyal ginger1-Apr-11 4:23
Memberloyal ginger1-Apr-11 4:23 
AnswerRe: SQL question Pin
Wendelius31-Mar-11 10:14
mveWendelius31-Mar-11 10:14 
GeneralRe: SQL question Pin
loyal ginger31-Mar-11 11:17
Memberloyal ginger31-Mar-11 11:17 
QuestionThis one has me stumped Pin
Andy Brummer31-Mar-11 7:01
sitebuilderAndy Brummer31-Mar-11 7:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.