2024-03-17T13:03:38Z 2024-03-17T13:03:38Z

<br/>Transaction, same as all the concept in computing, is an approach and trade-off - <a href="http://www.allthingsdistributed.com/2007/12/eventually_consistent.html">http://www.allthingsdistributed.com[..]d.com/2007/12/eventually_consistent.html</a> <br/><br/>Transaction file system - <a href="http://www.infoq.com/news/2008/01/file-systems-transactions">http://www.infoq.com/news/2008/01/file-systems-transactions</a> <a href="http://myjavatricks.com/jtfs.aspx">http://myjavatricks.com/jtfs.aspx</a> <br/><br/>Explanation about database isolation level - <a href="http://highscalability.com/blog/2011/2/10/database-isolation-levels-and-their-effects-on-performance-a.html">http://highscalability.com[..]-and-their-effects-on-performance-a.html</a> <a href="https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html">https://begriffs.com[..]08-01-practical-guide-sql-isolation.html</a> <br/><br/>A nice article explain about transaction process - <a href="http://www.theserverside.com/articles/article.tss?l=Nuts-and-Bolts-of-Transaction-Processing">http://www.theserverside.com[..]Nuts-and-Bolts-of-Transaction-Processing</a> <br/><br/><a href="http://vladmihalcea.com/2014/01/05/a-beginners-guide-to-acid-and-database-transactions/">http://vladmihalcea.com[..]guide-to-acid-and-database-transactions/</a> <br/><br/>SQL Transactions and ACID Properties - <a href="https://levelup.gitconnected.com/sql-transactions-and-acid-properties-bb5b670538f8">https://levelup.gitconnected.com[..]actions-and-acid-properties-bb5b670538f8</a> <br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

2024-03-17T13:03:38Z 2007-03-30T11:22:20Z 2007-03-30T11:22:20Z

<br/>Improve scalability via turn off transaction... do you think it will work?<br/><br/><a href="http://martinfowler.com/bliki/Transactionless.html">http://martinfowler.com/bliki/Transactionless.html</a> <br/><br/>I think this Idempotency help a lot if we like to implement system in this way: <a href="http://www.artima.com/intv/distribP.html">http://www.artima.com/intv/distribP.html</a> or example is soft update <a href="http://www.mckusick.com/softdep/">http://www.mckusick.com/softdep/</a> <br/><br/>Follow up discussion - <a href="http://www.artima.com/forums/flat.jsp?forum=276&thread=200350">http://www.artima.com/forums/flat.jsp?forum=276&thread=200350</a> <br/><br/>Already get two comments from friends, there is the key points:<br/><br/>=== Rob <br/>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.<br/>=== Rex<br/>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.<br/>Carfield Yim: handle rollback yourself you mean?<br/>Rex: <br/>u've to understand what is a system before talking the details...<br/>different application can apply different rollback.<br/>online/batch different are different.<br/><br/>Rule 1. make your txn simple.<br/>if it can't be simple, your design must have problem<br/><br/>u have to understand your capacity & limitation..... such article is meaningless if you have no actual requirement...<br/>if client is requiring 500 txn, that's no pt to have it like that.<br/><br/><script type="text/javascript"><!--google_ad_client = "pub-9426659565807829";google_ad_slot = "9359905831";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

2007-03-30T11:22:20Z