Existing code, found in compilation of runtime to run 1 minute to the last line statements by, what reason, how to solve?
The following code is used when a user logs in, speed is slow,
Fm_DaBa. QryUser. Close;
Fm_DaBa. QryUser. SQL. The Clear;
Fm_DaBa. QryUser. SQL. Text:='select * from the UserName where EUser=' "+ LoginEUser +" '"';
If not Fm_DaBa. QryUser. Prepared then Fm_DaBa. QryUser. Prepare;
But the other speed quickly, the following:
Fm_DaBa. Qry1. SQL Text

CodePudding user response:

Soy sauce, pass by say,

CodePudding user response:

The statements you receive analyzer in execution see if it is slow, you can see the execution time

CodePudding user response:

The parser using the above code needs to be long enough, other similar statements are soon,

CodePudding user response:

reference yirudangnian reply: 3/f

in the analyzer using the above code needs to be long enough, other similar statements are soon,

That means the slow SQL
May not be the index