transaction in WS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 15 Nov 2004 20:29 GMT

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

Reply to this Message

Christoph Schittko [MVP] - 16 Nov 2004 04:19 GMT

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:Ken@discussions.microsoft.com]
[quoted text clipped - 17 lines]
>
> Ken

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...