When you say one-by-one. do you mean you are committing each and every
row as you save it?
I don't know if there is any faster way than
(* Psuedo code *)
d1.starttransaction
d2.starttransaction
d1.findfirstrow
while not d1.eof do begin
d2.insertfromrow(d1)
d2.next
end;
d1.commit
d2.commit
(* END *)
interbase does not support batch operations yet.
you could always convert the data into a text file of Insert statements,
(* if there were no blobs *) and then write a script to execute them on
the new table, but i doubt that would be faster.
Paul Lowman wrote:
Whats the best way of copying selected records from one database/table to
another database/table. I am currently doing it one by one and it is very
slow ... ;-(
Cheers
Paul Lowman
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
