"Refresh" and "RefreshQuick(true)" functions

[MNosouhi]

Good Day.
i test "Refresh" and "RefreshQuick(true)" functions with a sampleProject that has 100000 record.
my code is:

Code: Select all

var t:TTime;
    i:Int64;
begin
 t:=Time;
 MSQuery1.RefreshQuick(True);
 //MSQuery1.Refresh; 
 i:=MilliSecondsBetween(Time,t);
 Label1.Caption:=IntToStr(i)
end;

Result:
When Use "Refresh" function , The Time Of Refresh is 700ms.

When Use "RefreshQuick(True)" function and no record is Deleted with other client , The Time Of Refresh is 30ms.

but When Use "RefreshQuick(True)" function and a record was Deleted with other client , The Time Of Refresh is 3100ms.

why?(3100ms is the long time in comparison with 700ms and 30ms)

best regard.

[Antaeus]

I could not reproduce the problem with the last SDAC (4.35.1.15). Probably this problem depends on table structure and data.
Please send me a complete small sample at sdac*crlab*com to demonstrate it, including script to create table, generate data and fill the table with the data.

Also supply me the following information:
- exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- exact version of your IDE;
- exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

[MNosouhi]

i send a sample to : sdac*crlab*com

thanks.