al4629740
asked on
performance because of connection string? VB
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=xxxxxxxx xxxxx"
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.
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=xxxxxxxx
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.
Well, how did you allocate your Azure database? Did you put it in a region that is across the world or one that is geographically close to your web server?
by moving to Azure, you have added latency (time to go over the Internet connection to reach your database). Local will always be faster!
ASKER
The only problem is the on prem was faster and by that I mean going over the internet also. Users need to access the DB from remote locations using the app.
On prem will always be faster. You might want to revisit your queries. If you are only doing SELECT * with no WHERE clause and have your application to filter that you need, you might have some performance improvements by limiting both the rows and the columns you are returning from the server to the application.
If you don't have too many users, maybe just having them to connect on a terminal using something like a remote desktop (RDP) would be better.
But again, on prem will always be faster.
If you don't have too many users, maybe just having them to connect on a terminal using something like a remote desktop (RDP) would be better.
But again, on prem will always be faster.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.