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?
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.