Where should I start a transaction?
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
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?

Report | Quote This | Send private message | Reply | Print

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.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact