| Author |
differentbetween batchUpdating and transaction
|
anarkali perera
Ranch Hand
Joined: Sep 10, 2009
Posts: 237
|
|
what is the differentbetween batchUpdating and transaction?
both execute the one or more sql statements
|
 |
Jan Cumps
Bartender
Joined: Dec 20, 2006
Posts: 2343
|
|
Rough explanation:
Batch update: you send a set of updates to the server in group in stead of one by one.
Transaction: a set of queries that logically belong together. The changes are only visible to other users when you commit the transaction. They are all reverted to the situation before the transaction started if you rollback.
|
OCUP UML fundamental
ITIL foundation
|
 |
 |
|
|
subject: differentbetween batchUpdating and transaction
|
|
|