468,283 Members | 1,673 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,283 developers. It's quick & easy.

transaction in WS

Ken
hi

I have an Async WS updating my SQLserver DB
80 clients are connecting to the WS all day updating the DB
I have only ONE UPDATE instruction in the WS

I dont want to have conflicts with the data and I realy need to take care
of this

my question:

Should I include the SQL into a transaction, is it needed?

Ken

Nov 21 '05 #1
1 1122
Ken,

Transactions are needed only if you want to coordinate more than one
operations, i.e. if you need all INSERTs, UPDATEs or DELETEs grouped
into a transaction to succeed or fail as a whole.

If you only ever have one database operation -- the UPDATE that you
mention -- then you don't need a transaction. In fact, you shouldn't
start a transaction because it's causing unnecessary overhead.

HTH,
Christoph Schittko
MS MVP XML
http://weblogs.asp.net/cschittko

-----Original Message-----
From: Ken [mailto:Ke*@discussions.microsoft.com]
Posted At: Monday, November 15, 2004 2:29 PM
Posted To: microsoft.public.dotnet.framework.webservices
Conversation: transaction in WS
Subject: transaction in WS

hi

I have an Async WS updating my SQLserver DB
80 clients are connecting to the WS all day updating the DB
I have only ONE UPDATE instruction in the WS

I dont want to have conflicts with the data and I realy need to take care of this

my question:

Should I include the SQL into a transaction, is it needed?

Ken


Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by TZoner | last post: by
3 posts views Thread by Thiko | last post: by
2 posts views Thread by Deepak Mehta | last post: by
1 post views Thread by Avanish Pandey | last post: by
15 posts views Thread by Zeng | last post: by
1 post views Thread by Hubert Fröhlich | last post: by
1 post views Thread by Matik | last post: by
2 posts views Thread by Ryan Liu | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.