AddNew method is slow (ODBC, Oracle 8.1.5)

From: Mike Layng <mlayng_at_micromine.com.au>
Date: Thu, 16 Mar 2000 11:16:03 +0800
Message-ID: <953176689.155533@lennon.vianet.net.au>

Hi,

We have an application that has always run on a DOS Paradox database. We are now trying to implement Oracle and SQL Server through ODBC via the Microsoft Jet Engine.

We have a couple of tables in the database that have somewhere in the magnitude of 1-1.5 million records.

When I attempt to add records to one of these tables using the following code:

Set rst = db.OPenRecordset ("table")

do ...

      rst.Addnew
      rst ("field1") = value1
      rst ("field 2") = value2
      rst.Update

loop

The very first call of the Addnew function is taking about 3 minutes! Subsequent calls seem fine.

Can someone tell me what is actually happening on that first Addnew, and whether there is something I could do either at the code level or database level to try and resolve this?

The tables have a primary index defined and should have plenty of space allocated to them in the database.

Thanks,
Mike. Received on Wed Mar 15 2000 - 21:16:03 CST