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>
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