Now the user USES the SQL SERVER 2008, currently has been installed on the SERVER database, initialization, on the SERVER and everything is normal, perfectly normal access,
But at the time of client access, very, very slow (sometimes even suggest connection failure),
Give advice or comments please!
CodePudding user response:
Do not know how to start on this question!CodePudding user response:
Check the network environment, eliminate the network factors, and then talk about the software problem,CodePudding user response:
Network is very normal, copying files from the server is quite normal,CodePudding user response:
Program to load the table if a to obtain all data (such as SELECT * FROM tbl_XXX)?Whether the data in the table contains field picture?
Whether the master-slave form according to the show? Whether from record with refresh when there is no rolling master record?
According to the data collection of dynamic drawing interface? To optimize the interface refresh if need!
How many links at the same time using the server?
Data throughput?
.
Does this situation many, many!
CodePudding user response:
I think you should test first connect to the database, for example, to create a new text file, right click, save as, all files, a.u dl preservation,And then double-click the udl choose SQL server connection, input all kinds of information, under the test connection is normal,
Because no matter how you explain, this has nothing to do with Delphi,
CodePudding user response:
It even sql2005 normal?CodePudding user response:
Is your program installed on the server is normal?Another server or client have antivirus software?
CodePudding user response:
Looking from the situation: the connection is slow, data transmission,If so, is the problem on the local area network (LAN) Settings, must be set static IP address,
CodePudding user response:
1. All the client is in this way, or a part?2. Whether the initial connection to manipulate data more watch?
3. The timeout is set too small?
4. Can be in a client with SQL client, to test, is a network problem or the software itself
.
CodePudding user response:
Continuous Ping, Ping the server on the client, will see packet loss?CodePudding user response:
Under limited database memory give it a tryCodePudding user response:
This problem and look at the network and server configuration,The building Lord write enough detail is hard to judge,
CodePudding user response:
View of Delphi idle died, the analysis of the problems so powerfully