[Koha-cvs] koha/updater updatedatabase

[paul poulain]

CVSROOT:        /sources/koha
Module name:    koha
Changes by:     paul poulain <tipaul>   07/05/23 16:33:10

Modified files:
        updater        : updatedatabase 

Log message:
        skip move to innoDB for the 4 22 tables, that are used to store MARC 
records, are useless in Koha 3.0 The process is very very long, so the 
updatedatabase should speed up a lot (by long I mean 1 hour on my Dual core 
with SCSI disk, for a 50 000 biblios long table

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&r1=1.164&r2=1.165

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.164
retrieving revision 1.165
diff -u -b -r1.164 -r1.165
--- updatedatabase      4 May 2007 16:24:09 -0000       1.164
+++ updatedatabase      23 May 2007 16:33:10 -0000      1.165
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.164 2007/05/04 16:24:09 tipaul Exp $
+# $Id: updatedatabase,v 1.165 2007/05/23 16:33:10 tipaul Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -1571,14 +1571,14 @@
 $sth = $dbh->prepare("show table status");
 $sth->execute;
 while ( my $table = $sth->fetchrow_hashref ) {
-     if ($table->{Engine} ne 'InnoDB') {
-         $dbh->do("ALTER TABLE $table->{Name} TYPE = innodb");
-         print "moving $table->{Name} to InnoDB\n";
-     }
     next if $table->{Name} eq 'marc_word';
     next if $table->{Name} eq 'marc_subfield_table';
     next if $table->{Name} eq 'auth_word';
     next if $table->{Name} eq 'auth_subfield_table';
+     if ($table->{Engine} ne 'InnoDB') {
+         $dbh->do("ALTER TABLE $table->{Name} TYPE = innodb");
+         print "moving $table->{Name} to InnoDB\n";
+     }
     unless ($table->{Collation} =~ /^utf8/) {
          print "moving $table->{Name} to utf8\n";
         $dbh->do("ALTER TABLE $table->{Name} CONVERT TO CHARACTER SET utf8");
@@ -2034,6 +2034,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.165  2007/05/23 16:33:10  tipaul
+# skip move to innoDB for the 4 22 tables, that are used to store MARC 
records, are useless in Koha 3.0 The process is very very long, so the 
updatedatabase should speed up a lot (by long I mean 1 hour on my Dual core 
with SCSI disk, for a 50 000 biblios long table
+#
 # Revision 1.164  2007/05/04 16:24:09  tipaul
 # various bugfixes on parameters modules + adding default NoZebraIndexes 
systempreference if it's empty
 #