Refresh and requery (Speed test)
Posted: 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 ?
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 ?