Hi guys,

I created 2 programs that updates 3 sql tables.

both programs uses remote views to update the 3 tables.

the first program uses plain remote views while the second program wraps the tables in a SQL Transaction to submit the changes atomically.

I noticed that there is a great performance discrepancy between the two when it comes to the speed of processing. The first program is about 20 to 30 times faster than the second program. I tested the duration using SQL Profiler.


Is there a possible way to speed up the processing when using SQL Transactions?