>You can keep a counter and only send updates every 100 commands for example (just build a string with all the commands, reset the counter and the string after you have sent the update). I have done this and it works OK, but you may need to experiment with the counter to find the best performance.
>
>I have turned on profiler (SQL Server) and examined the commands that are generated when doing updates with remote views. Most of this code is pretty tight, so it may be more trouble than it is worth to convert to SPT.
>
>I haven't studied your code in detail, but if you want the optimal peformance I would think that you should be doing these updates with a stored procedure (especially when doing batch updates / inserts).

Ummm. Stored procedures are not necessarily faster. I called a stored procedure with a parameter that did the same query as a "dynamic" query I sent with the parameter and the stored procedure took 2x longer.

Check out the stored procedure always faster thread.