[Koha-cvs] koha/misc/migration_tools bulkmarcimport.pl

[Antoine Farnault]

CVSROOT:        /sources/koha
Module name:    koha
Changes by:     Antoine Farnault <toins>        07/06/08 09:41:14

Modified files:
        misc/migration_tools: bulkmarcimport.pl 

Log message:
        it's faster to 'truncate' instead of using 'delete from'...

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/migration_tools/bulkmarcimport.pl?cvsroot=koha&r1=1.10&r2=1.11

Patches:
Index: bulkmarcimport.pl
===================================================================
RCS file: /sources/koha/koha/misc/migration_tools/bulkmarcimport.pl,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -b -r1.10 -r1.11
--- bulkmarcimport.pl   29 Mar 2007 13:30:32 -0000      1.10
+++ bulkmarcimport.pl   8 Jun 2007 09:41:14 -0000       1.11
@@ -182,9 +182,9 @@
 
 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";