[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