Optimize Select insert and update

  • Thread starter Thread starter User
  • Start date Start date
U

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 :)
 
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.
 
Thanks Brian,

I will work on it :)

Xelk

Brian said:
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.
Click to expand...
 
Back
Top