> Have you considered bulk loading the new data into a temp table and then
> merging it into the main database - overall the load would be slower
> (indices being updated constantly) but the database would be continually available
>(you
> could use a server side process to merge)
Worth considering. The total time taken for load though would still be long. It becomes
a problem when want to use the new data very soon after arrival. Otherwise
the availability issue isnt a problem.
Thanks
----------------------------------------------------------
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"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
