<div>
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?
</div>


<div>
by moving to Azure, you have added latency (time to go over the Internet connection to reach your database). Local will always be faster!
</div>


<div>
The only problem is the on prem was faster and by that I mean going over the internet also. &nbsp;Users need to access the DB from remote locations using the app.
</div>


<div>
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.<br />
<br />
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.<br />
<br />
But again, on prem will always be faster.
</div>


al4629740

<div>
<div class="content wysiwyg-content">
Are there connections to a DB that are faster than others over the internet? &nbsp;I use the following string for my vb6 app to access microsoft azure sql db. &nbsp;<br />
<br />
Set conn = New ADODB.Connection<br />
Set rec = New ADODB.Recordset<br />
conn.Open &quot;Provider=sqloledb;Data Source=&quot; &amp;&nbsp;ConnectionIP &amp;&nbsp;&quot;,1433;Network Library=DBMSSOCN;Initial Catalog= TrackingDB; User ID=xxxxx;Password=xxxxxxxx<wbr />xxxxx&quot;<br />
<br />
Or maybe it doesn't make a difference when it comes to performance? &nbsp;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. &nbsp;The local db was faster when accessed over the internet compared to the Azure which has the same scenario being located in the cloud.
</div>
</div>


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.

performance because of connection string? VB

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.