CODEWITHSUNDEEP
.netdata-accesssqltransaction
Popeye
Popeye

Reputation: 43

When should I use a SQLTransaction

What is the appropriate time to use a SQLTransaction?

I use them for all of my INSERT, UPDATE and DELETE statements.

Is this the correct usage or am I doing a bit of overkill?

Upvotes: 4

Views: 2062

Answers (3)

Mark Byers
Mark Byers

Reputation: 839114

Use a transaction when you want a series of statements to be treated atomically - that is either they all succeed and are committed, or they are all rolled back.

Since simple statements are already atomic you don't need to explicitly create a transaction around each and every individual statement.

Upvotes: 7

prilldev
prilldev

Reputation: 304

You only need a transaction if you plan to do multiple statements, and plan to rollback all of the data changes that resulted from the statements if an error somewhere down the line occurs. Wrapping single update/delete statements is not needed. If an error occurs with a single command, simply catch and handle the error in your front-end code.

Upvotes: 2

Josh
Josh

Reputation: 12566

If your commands are only single issued, and not a group, then it is probably overkill. Transactions are used to group sql commands together, a group that must have all members succeed, or none at all.

http://en.wikipedia.org/wiki/Atomicity_%28database_systems%29

Upvotes: 2

Related Questions