[Koha-bugs] [Bug 12488] bulkmarcimport.pl -d option should use DELETE instead of TRUNCATE

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488

wajasu <matted-34813 at mypacks.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |matted-34813 at mypacks.net

--- Comment #4 from wajasu <matted-34813 at mypacks.net> ---
FYI: If we move to DELETE FROM it will take longer as its a DML command and can
be rolled back.   TRUNCATE is a DDL command and is autocommitted, recreating
the tables and indexes, with AUTO_INCREMENT starting over. So we must consider
if we want to reset AUTO_INCREMENT on the table when using DELETE FROM as well.
( ALTER TABLE thetable AUTO_INCREMENT = 1 ).
Also, an understanding of bulkimport.pl and the implications for folks with
huge imports, and the resulting rollback support.

-- 
You are receiving this mail because:
You are watching all bug changes.