Re: Speeding up import

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Fri, 16 Mar 2001 11:28:56 GMT
Message-ID: <3ab1f7be.6944659@news-server>

On Fri, 16 Mar 2001 11:14:09 GMT, willjamu_at_mindspring.com (James Williams) wrote:

>>
>>2. commit = no
>
>Means good rollbacks!

Not necessarily if done together with 3 below and there are no constraints.

>
>>3. indexes =n
>> and then create indexes separetely

Mass inserts (what import does) do not use up rollback. What uses up rollback is if there is an index already on the table before the inserts start.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Mar 16 2001 - 05:28:56 CST