From 4728830e34d19a8474c3c304a54ff2af1b44319e Mon Sep 17 00:00:00 2001 From: toins Date: Fri, 8 Jun 2007 09:41:14 +0000 Subject: [PATCH] it's faster to 'truncate' instead of using 'delete from'... --- misc/migration_tools/bulkmarcimport.pl | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/misc/migration_tools/bulkmarcimport.pl b/misc/migration_tools/bulkmarcimport.pl index 513291e103..9ac6ee54c8 100644 --- a/misc/migration_tools/bulkmarcimport.pl +++ b/misc/migration_tools/bulkmarcimport.pl @@ -182,9 +182,9 @@ my $dbh = C4::Context->dbh; if ($delete) { print "deleting biblios\n"; - $dbh->do("delete from biblio"); - $dbh->do("delete from biblioitems"); - $dbh->do("delete from items"); + $dbh->do("truncate biblio"); + $dbh->do("truncate biblioitems"); + $dbh->do("truncate items"); } if ($test_parameter) { print "TESTING MODE ONLY\n DOING NOTHING\n===============\n"; -- 2.20.1