I wrote a Delphi procedure, on the phone to read another machine access tables: code
T1: now=();///execution code before the time
LocalManulDisp (FormManual. CxComboBox1. ItemIndex + 1);//this is the code reads a join table
T2: now=();///code execution time after
FormManual. Edit1. Text:=timetostr (t1, t2);///get code execution time,,,

//////////////////////////////////////link table as follows/////////////////////
With FormData. GHQuery1 do
The begin
The Close;
SQL. The Clear;
SQL. The Add (' select * from 1 # ManulSummaryDisp where ManulON=true ");
The open;
end;
//////////////////////////////////////////////////////////
Found that need 4 s time, code execution,,, what a great god knows how to modify, make speed,,,

CodePudding user response:

Adding ManulON field index
The access database is inherently slow, if the data amount is larger, the fairy didn't also way,

CodePudding user response:

ACCESS to another computer through the network ACCESS database is relatively slow, if the network is not clear will delay some time, as the upstairs said, adding a index will hurry up