>Hi Dave ----
>
>Thats also one of the methods I have tried.......the doggone thing is that remote views work perfectly until you are in a data migration situation where you have to push mass records through the pipe. Eventually, I get this thing to work but usually in a manner that is *very* slow.
>
>Thank God that this is a one-time migration....I'd otherwise have a nervous breakdown :-)
>
>Thanks!

Have you turning off automatic transactions? Seems to me that that might slow things down, for it to create a transaction for every uppdate. Also, what is your batch update setting? You may want to bump this number up to increase performance.

From the doc...

Records to batch update

Specifies the number of update statements sent at once for views. The default is 1. Adjusting this value can greatly increase update performance. For more information, see the REPLACE command and Scope Clauses.


BOb