Optimize Select insert and update

[User]

Hi folks,

Here is what I do:
I perform a SELECT to see if a record is in the DB before performing an
INSERT or UPDATE. I am receiving massive information to place in the
DB. Is there a better way to do it?

I use ADO recordset and ADO connector. Access 2000, win 2000.

Thanks

 

[Brian Camire]

A "bulk" approach is often faster than a "record at a time" approach".

So, you might try to create a linked table to the source data (or, if this
is not possible, insert the data into an intermediate table), and then run
one insert query and one update query to move data from the linked table (or
intermediate table) to the destination table.

 

[User]

Thanks Brian,

I will work on it

Xelk

A "bulk" approach is often faster than a "record at a time" approach".

So, you might try to create a linked table to the source data (or, if this
is not possible, insert the data into an intermediate table), and then run
one insert query and one update query to move data from the linked table (or
intermediate table) to the destination table.