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