Re: insert many records in short time

Oracle8 has this new feature of bind array inserts. It's very fast indeed. It's aprox. 3 times faster as normal inserts We made a script inserting 100.000 records (8 column table, 6 filled; 4 indexes on it)
which completed in 20 seconds. this was 3 times faster as the normal way. Without the indexes it would be finished within 14 seconds --> 4 * 100.000 = 400.000 inserts per minute --> 400.000 * 30 = 12.000.000 inserts in half an hour!!!

Hope it helps all you people out there!!

-John

><jimcao_at_my-dejanews.com> wrote in message
>news:7fmcnj$lb2$1_at_nnrp1.dejanews.com...
>> Hi all,
>> Is it possible that I insert about 6,000,000 records into one table
>> in half an hour? The table has 4 fields.
>> Does somebody know any solution ?
Received on Fri Apr 23 1999 - 13:17:33 CDT