[Therion] file.sql format

Vasily Vl. Suhachev v_su at inbox.ru
Sat Aug 3 04:02:42 CEST 2013


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



More information about the Therion mailing list