Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |