M
Maury Markowitz
I have a table on a slow database that I need to work with all the
time. In order to improve performance, I cache the columns we use a
lot on our local SQL Server.
In an MDB I can INSERT into my local table using a SELECT from the
remote one. I'm trying to duplicate this under an ADP, but so far all
I can come up with is looping over the rows. I open a connection to
the slow DB using a static read-only ODBC link, another to my local
table, and then loop over the first inserting individually into the
second.
Can anyone suggest an faster way to do this?
Maury
time. In order to improve performance, I cache the columns we use a
lot on our local SQL Server.
In an MDB I can INSERT into my local table using a SELECT from the
remote one. I'm trying to duplicate this under an ADP, but so far all
I can come up with is looping over the rows. I open a connection to
the slow DB using a static read-only ODBC link, another to my local
table, and then loop over the first inserting individually into the
second.
Can anyone suggest an faster way to do this?
Maury