On Tuesday 13 November 2007, Iñaki Baz Castillo wrote: > Hi, MySQL tables of OpenSer created by the script are "MyISAM". Is there > any reason for that instead of using InnoDB? > > As I know: > > MyISAM: > - Is faster reading and writting (except writting various entries to same > table since it blocks the entire table). > - No transactions or rollbacks. > - Small disc space requeriments. > > InnoDB: > - Transactions, rollbacks, restrictions in foreing keys. > - Faster writting various entries in same table (entry lock instead of > table lock). > - More disc space and RAM requeriments. > > > Yes, it can be obvious that for OpenSer the engine MyISAM can be a good > choice but I would like to know if there is more data for this choice.
Hi Iñaki Baz, just a short note: This can be easily changed (for 1.3) in the db/schema/entities.xml file, for 1.2 there should exists a parameter in the script. Cheers, Henning _______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
