A. Avoid coding unnecessary long-running transactions.
B. Allow the database to handle locks in default locking mode.
C. Always explicitly code the locks as per the requirement of the application.
D. Allow escalation of row locks to block locks if too many row locks cause problem.
答案:(A、B)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1239860/ ,如需转载,请注明出处,否则将追究法律责任。