which one is faster for appending, TMyTable or TMyQuey
Posted: Tue 07 Sep 2010 12:58
Helllo
I have millions of records, each one after very complicated calculation, need to be insert back to the result table.
I first clear up the result table. then for millions of result, I need to
I have already set the CashedUpdate, StrictUpdate, UniDirection, AutoPrepare etc for speed tunning, but performance is not satisfying.
I would like to know:
1. is this the best way for dataset append operation?
2. for append speed, which component I should use for faster speed? a TMyQuery or a TMyTable;
I have millions of records, each one after very complicated calculation, need to be insert back to the result table.
I first clear up the result table. then for millions of result, I need to
Code: Select all
source_dataset.first;
while not source_dataset.eof do
begin
dest_dataset.append;
// now copying selected fields of source into dest
// finished copying
dest_dataset.post;
source_dataset.next;
end;
I would like to know:
1. is this the best way for dataset append operation?
2. for append speed, which component I should use for faster speed? a TMyQuery or a TMyTable;