From: Jiří Č. <ji...@ci...> - 2016-10-26 04:37:25
|
When the two transactions update same record *at the same time*, there's nothing you can do it. One will fail. You can minimize that keeping the transactions as short as possible. Comparing TX handling with MySQL is wrong; I guess you used MyISAM tables, where TXs are virtually non-existent. Try any other real DB and you'll get the same problem. -- Mgr. Jiří Činčura Independent IT Specialist |