Re: inserting many records with ADO is very slow

From: Stefan Felkel <stefan.felkel_at_cim-team.de>
Date: 16 Sep 2004 04:29:41 -0700
Message-ID: <d705870.0409160329.2133674@posting.google.com>

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<vH92d.442183$%_6.436342_at_attbi_s01>...
>
> My guess is that you are committing after each record. Ouch. Also you are

Definitely not - except ADO does it automatically. The Application does the following:

Open a connection
- BeginTrans
  - Add some records
  - Change some other records
  - Delete some other records
- CommitTrans
Close the connection

> not using an array interface which anyone would use to get good
> performance.

Not ADO, i guess. Received on Thu Sep 16 2004 - 06:29:41 CDT