[Koha-devel] CVS: koha/updater updatedatabase,1.1,1.2

[Chris Cormack]

Hi Steve

  Looks like the updater is coming along nicely.
I wonder if it would be worthwhile to do some kinda check the mysql
version running, and if its newish .. make the tabletypes become MyISAM ..
which allows for the fulltext searching etc. 

At the moment because a table type is not specified in the database creation
sql, the tables will be whatever the default table type was at the time the
database was created.

For HLT .. we started off with an old debian stable version of Mysql which
meant our table types were all ISAM.
Ive gone thru and made them all MyISAM which has helped performance a little.
I think MyISAM is now the default and in version 4 on InnoDB will be the new
default.

But If we want fulltext indices we will need the table types to be either
MyISAM or we could go cutting edge InnoDB ?

Just thinking aloud

Chris

-- 
Chris Cormack                                                     Programmer
025 500 789                                        Katipo Communications Ltd
chris at katipo.co.nz                                          www.katipo.co.nz