R
rmgalante
I have a web application running on a web farm with a separate
database server. I use DAAB in my business objects to update with the
database. I was using TransactionScope around two or three business
object updates. All business objects use the same db connection. But
the update was very slow. After the LTS (not DTC - only 1 connection)
spins up the update is faster, but the site is not heavily loaded yet,
so every user that visits the site experiences a very slow update time
(15 to 20 seconds). I imagine that this wouldn't be a problem on a
heavily used site.
So I switched to the DAAB DbTransaction. I use one connection and one
transaction for all the updates. The update time is 5 seconds.
Why am I experiencing faster response times with the DAAB
DbTransaction object?
database server. I use DAAB in my business objects to update with the
database. I was using TransactionScope around two or three business
object updates. All business objects use the same db connection. But
the update was very slow. After the LTS (not DTC - only 1 connection)
spins up the update is faster, but the site is not heavily loaded yet,
so every user that visits the site experiences a very slow update time
(15 to 20 seconds). I imagine that this wouldn't be a problem on a
heavily used site.
So I switched to the DAAB DbTransaction. I use one connection and one
transaction for all the updates. The update time is 5 seconds.
Why am I experiencing faster response times with the DAAB
DbTransaction object?