Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: insert many records in short time
John Vernes wrote:
>
> 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!!!
Can you post a skeleton source?
Thank you,
-Acacio Received on Sun Apr 25 1999 - 05:00:19 CDT
![]() |
![]() |