How to Refresh just X records in uniquery

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
flyy
Posts: 17
Joined: Fri 18 Sep 2009 08:34

How to Refresh just X records in uniquery

Post by flyy » Wed 13 Jan 2010 10:47

hi,

for ex: I have a table which has more than 10.000 record. after some operations I know that some records values has changed and I have the key values of that changed records.

which way is the best to refresh these records. I did some tests, first tried full refresh and secondly locate this records and just refresh them by RefreshRecord procedure (also created an index on locate field ). if count of records is 7 trying to locate and refresh them one by one is more slow than full refresh.

which way is the best? is there a better way?

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 14 Jan 2010 08:22

I think you should use full refresh.

Post Reply