Where should I start a transaction?
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Greg_Benson
Posted On:   Tuesday, May 8, 2001 09:40 AM

I have a 3 tier architecture. Which tier should I start the transaction? I have one person recommending that it be as close to the database as possible. The other person recommends that it start in the client (1st tier) in order to ensure that everything is included in the transaction. Would the second solution be much slower than the first? Does anyone know a specific site to read about this?

Re: Where should I start a transaction?

Posted By:   Amit_Nagar  
Posted On:   Tuesday, May 8, 2001 10:17 AM

One downside to starting a transaction on client side would occur if u include DB modifications in the trasaction context. U could potentially have deadlocks in ur system. The transactions should be kept as short as possible and close to the dtabase as is suggested by the first person. Thanks.
About | Sitemap | Contact