The original program was written by Delphi2010, use of database is SQL SERVER, LAN is the edition, the boss now want to put the database in ali cloud, connected through, is too slow, do you have any good idea? Used to use adoquery and ADOConnection, please everyone a great god,

CodePudding user response:

Originally slow slow, originally not slow, then the solution, and not in local access remote database, you want to put them on the cloud, is a database service (no public join), an application service (there can be a public network connection, good service, with the database using a network connection, of course can also be on a cloud), the database never directly exposed to the public, that is a fault,

CodePudding user response:

LAN access latency in milliseconds, public access in 100 millisecond even more, small amount of frequently accessed data performance is surely not

CodePudding user response:

Not speed problem, also can be configured through ODBC, is the special slow, with ali cloud hosting

CodePudding user response:

I said is not speed, is the network delay, speed faster, can solve the problem of continuous data transmission, such as download/upload a file, but cannot solve the small amount of frequently accessed data performance, routing public on each level, will increase more than a dozen to a few milliseconds delay

CodePudding user response:

Tested under these days, found not like network problems, estimate or the problem of software architecture, replace part of the code with three layers architecture, once mentioned to speed,

CodePudding user response:

In LAN speed is not slow, can also,

CodePudding user response:

Still want to walk the path, with three layers, don't expose database out,

CodePudding user response:

https://blog.csdn.net/pcwe2002/article/details/52527782
Modify the connection string in this way can solve the problem of outer net is slow and easy to drop

CodePudding user response:

Wan, should walk three layer, rather than directly move the layer 2,

CodePudding user response:

Use three layer structure, database and application server in the cloud, should be ok, two layers of database directly exposed too terrible

CodePudding user response:

Set up the VPN speed a lot, also save trouble,

CodePudding user response:

This will certainly slow, do not know whether have experienced now kingdee KIS, remote access way to do it, basic need not change the original software, speed of leverage,