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

Antoine Farnault antoine at koha-fr.org
Fri Jun 8 11:41:14 CEST 2007


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";





More information about the Koha-cvs mailing list