How to insert data fast
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Thu, 14 Jul 94 10:16:00 -0500
Message-ID: <12a.3329.905_at_compudata.com>
Date: Thu, 14 Jul 94 10:16:00 -0500
Message-ID: <12a.3329.905_at_compudata.com>
-> Q1,Are there way to tuen Redo Log off?
-> If someone knows it, Please tell me.
-> If Redo Log turned off,data insert would be much faster,wouldn't it?
-> Q2,What parameters do I have to change in order to fast data insert
-> ?
You can't turn it of, but you can turn off archivelog mode, which might speed you up a little bit (not much, though).
If you are not worried about transaction integrity, you should batch the records and only commit once every 100 or so. That'll make a huge difference. Also, if you re-write to use arrays, that will make a big difference. Received on Thu Jul 14 1994 - 17:16:00 CEST