Re: loader

From: Jason Judge <jason.judge_at_virgin.net>
Date: Mon, 18 Oct 1999 22:45:56 +0100
Message-ID: <7ug3qk$oi$1_at_nclient15-gui.server.virgin.net>


One way to speed up the load is to order the data in the files in primary key order to start with. This puts less load on the database.

With a decent machine you should be able to load that many records well within an hour (I'm making a lot of assumptions there though). If this is a one-off exercise then you may be better to give more time to the machine to load your data rather than working out how to load it faster.

Again - many assumptions.

JJ Received on Mon Oct 18 1999 - 23:45:56 CEST

Original text of this message