Re: How can I improve the import speed of a large SQL file?
Turning off autocommit means that the entire file will be one transaction.
And then, I don't see the final COMMIT. Did it actually get saved?
A huge set of data is likely to be slower as a single transaction than a bunch of autocommitted INSERTs.
What is the source file like? Is it multi-statement INSERTs? Hopefully it is.
Subject
Views
Written By
Posted
21230
May 06, 2016 09:46AM
8187
May 06, 2016 11:49AM
5456
May 06, 2016 12:17PM
Re: How can I improve the import speed of a large SQL file?
5250
May 06, 2016 05:44PM
4633
May 08, 2016 04:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.