Sun Mar 17 13:03:38 GMT 2024 From /weblog/database/transaction

transaction

Transaction, same as all the concept in computing, is an approach and trade-off - http://www.allthingsdistributed.com[..]d.com/2007/12/eventually_consistent.html

Transaction file system - http://www.infoq.com/news/2008/01/file-systems-transactions http://myjavatricks.com/jtfs.aspx

Explanation about database isolation level - http://highscalability.com[..]-and-their-effects-on-performance-a.html https://begriffs.com[..]08-01-practical-guide-sql-isolation.html

A nice article explain about transaction process - http://www.theserverside.com[..]Nuts-and-Bolts-of-Transaction-Processing

http://vladmihalcea.com[..]guide-to-acid-and-database-transactions/

SQL Transactions and ACID Properties - https://levelup.gitconnected.com[..]actions-and-acid-properties-bb5b670538f8

(google search) (amazon search)

Fri Mar 30 11:22:20 GMT 2007 From /weblog/database/transaction

Transactionless system

Improve scalability via turn off transaction... do you think it will work?

http://martinfowler.com/bliki/Transactionless.html

I think this Idempotency help a lot if we like to implement system in this way: http://www.artima.com/intv/distribP.html or example is soft update http://www.mckusick.com/softdep/

Follow up discussion - http://www.artima.com/forums/flat.jsp?forum=276&thread=200350

Already get two comments from friends, there is the key points:

=== Rob
Not if everything works as intended. But if something goes wrong you might get an unexpected state in the database. Then you have to do more work in other places to deal with the fact that the database might be in a state that wasn't intended, but is theoretically possible because you didn't use transactions.
=== Rex
Rex: exactly the thing what i did in last year to boost up performance from 700 txn per second to more than 10K txn per second.
Carfield Yim: handle rollback yourself you mean?
Rex:
u've to understand what is a system before talking the details...
different application can apply different rollback.
online/batch different are different.

Rule 1. make your txn simple.
if it can't be simple, your design must have problem

u have to understand your capacity & limitation..... such article is meaningless if you have no actual requirement...
if client is requiring 500 txn, that's no pt to have it like that.

(google search) (amazon search)