Refresh and requery (Speed test)

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
hendrang
Posts: 6
Joined: Mon 28 Sep 2009 17:12

Refresh and requery (Speed test)

Post by hendrang » Wed 30 Sep 2009 02:25

I have tested the speed of TAdoTable method Requery and TUniTable Refresh (TUniTable has no requery method).


TAdoTable allways set FetchAll to True so for TUniTable I set FetchAll to True too. My table has 15.000 records, database Microsoft Access.
I founded that the Refresh of TUniTable has the same speed as Requery of TAdoTable (I means it's very fast ), since Refresh of TAdoTable is very slow.

If TUniTable/TUniQuery has Requery method, would it be faster than TAdotable/TAdoQuery Requery method ?
:D

Post Reply