Oracle has sqlldr which provides ultrafast bulk import of data into the database by
shutting down logging, transactions, dropping contraints and indices etc. Even if
you do these manually, SQLLDR still runs orders of magnitude faster. It moves
data into tables faster than I can copy file over net.
Now does Interbase have something similar? I want to add data, several million
records at a time, on regular basis and simple INSERTs dont cut it.
----------------------------------------------------------
Phil Scadden, Institute of Geological and Nuclear Sciences
41 Bell Rd South, PO Box 30368, Lower Hutt, New Zealand
Ph +64 4 5704821, fax +64 4 5704603
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
