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
