inserting many dataset

From: Strolch <m.bickel_at_ids-scheer.ch>
Date: Thu, 22 Jul 1999 16:18:31 +0200
Message-ID: <37972837.14C9F3F3@ids-scheer.ch>

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 Thu Jul 22 1999 - 09:18:31 CDT