cost of begin database transaction
up vote
0
down vote
favorite
all we know sql begin-commit-rollback approach to maintaining integrity of data in database but the question is what is the cost of starting and commiting empty transaction - empty i mean that literally no change to data is done between begin and commit transaction? is this cost so small that we should not bother and mid-scale systems? how does cost change when u rise isolation level? is this cost specific to chosen database engine? simple use case is to execute unit of work on rabbit mq subscriber side when not all logic would have to reach database to do their job.
database transactions
asked Nov 10 at 22:13
Macko
13119
add a comment |
up vote
0
down vote
favorite
all we know sql begin-commit-rollback approach to maintaining integrity of data in database but the question is what is the cost of starting and commiting empty transaction - empty i mean that literally no change to data is done between begin and commit transaction? is this cost so small that we should not bother and mid-scale systems? how does cost change when u rise isolation level? is this cost specific to chosen database engine? simple use case is to execute unit of work on rabbit mq subscriber side when not all logic would have to reach database to do their job.
database transactions
asked Nov 10 at 22:13
Macko
13119
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
all we know sql begin-commit-rollback approach to maintaining integrity of data in database but the question is what is the cost of starting and commiting empty transaction - empty i mean that literally no change to data is done between begin and commit transaction? is this cost so small that we should not bother and mid-scale systems? how does cost change when u rise isolation level? is this cost specific to chosen database engine? simple use case is to execute unit of work on rabbit mq subscriber side when not all logic would have to reach database to do their job.
database transactions
asked Nov 10 at 22:13
Macko
13119
all we know sql begin-commit-rollback approach to maintaining integrity of data in database but the question is what is the cost of starting and commiting empty transaction - empty i mean that literally no change to data is done between begin and commit transaction? is this cost so small that we should not bother and mid-scale systems? how does cost change when u rise isolation level? is this cost specific to chosen database engine? simple use case is to execute unit of work on rabbit mq subscriber side when not all logic would have to reach database to do their job.
database transactions
database transactions
asked Nov 10 at 22:13
Macko
13119
asked Nov 10 at 22:13
Macko
13119
asked Nov 10 at 22:13
Macko
13119
asked Nov 10 at 22:13
Macko
13119
asked Nov 10 at 22:13
Macko
13119
13119
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53243949%2fcost-of-begin-database-transaction%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
