Case 1 - New York University

Such as on DB2, add the option parameter “+c” before update transaction command to turn off auto-commit; and on SQL Server, auto commit also can be turned off. I tested the response time after I turned off auto commit of SQL Server. I found that auto-commit on/off doesn’t affect the response time – SQL Server still writes redo log only. ................
................