3 Aug
2013
3 Aug
'13
4:02 a.m.
Typically, SQL servers use transaction with autocommit on each command, and wrap a large block of commands in a single transaction on the contrary improves the performance 26.07.2013 04:07, Footleg пишет:
More commonly with large data imports of complete tables you do not want to use transactions as this slows down the operation, and if it was to fail for some reason (like an error in the SQL script) then you can just drop and recreate the tables to reset the database ready to try again.
-- WBR, Vasily