Re: inserting many dataset

From: Glen Gorman <Glen.Gorman_at_nbnet.nb.ca>
Date: Fri, 23 Jul 1999 15:51:34 -0300
Message-ID: <3798B9B6.1AEAD396@nbnet.nb.ca>

I have no idea why its slowing down, but you could use Oracle SQL*Loader, its the fastest thing around for loading Oracle data.

Strolch wrote:

> Hello
> We try to insert datas to an oracle 7.3 database within a VB6
> application by using ADO. In the application we have the datas in array
> and insert them set by set with an INSERT INTO ..." statement (more then
>
> 100'000 sets) into the oracle table. The table where the datas are
> inserted doesn't have any primary keys or indexes. Altough with each new
>
> record the time to execute the insert statement is growing.
> Why that?
> Is there a faster way to insert the datas (they doesn't come from an
> oracle database) from the array in the application into the oracle
> table?
>
> Hope someone can help.
>
> Thanks
>
> Strolch
Received on Fri Jul 23 1999 - 13:51:34 CDT