Are there connections to a DB that are faster than others over the internet? I use the following string for my vb6 app to access microsoft azure sql db.
Set conn = New ADODB.Connection
Set rec = New ADODB.Recordset
conn.Open "Provider=sqloledb;Data Source=" & ConnectionIP & ",1433;Network Library=DBMSSOCN;Initial Catalog= TrackingDB; User ID=xxxxx;Password=xxxxxxxxxxxxx"
Or maybe it doesn't make a difference when it comes to performance? The reason I ask is because ever since we migrated to Azure, the connection is a little slower than when I was accessing our local db. The local db was faster when accessed over the internet compared to the Azure which has the same scenario being located in the cloud.