Re: AddNew method is slow (ODBC, Oracle 8.1.5)

Hi,
I had a similar problem in a VB5 application I 'm now avoid to work with Recordsets in VB. Instead I do SQL Statements through the Jet-Database.
for example:
ssql = "insert into Table(column) values(value)" DataControl.Database.Execute ssql, dbFailOnError

ssql= "update Table set column=value"
DataControl.Database.Execute ssql, dbFailOnError

Christian

In article <953176689.155533_at_lennon.vianet.net.au>, "Mike Layng" <mlayng_at_micromine.com.au> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 16 2000 - 04:27:38 CST