I don't want to make a mistake.
I am about to put my website online and I admit I haven't thought about which MySQL engine to choose: MyISAM or InnoDB.
I read here and there that InnoDB should be preferred now. MySQL is version 5.1.63.
Context: Two MySQL servers,
serv1: one table with unique id. Call this table
serv2: one table
childon which id's are the same as
I have to update (and only this) my fields contained in
daddy with the fields of
child, where id's are the same. Indexes are on the columns that are important for the query.
So, to max performance out, should I stick with MyISAM or convert to InnoDB? I can still do it as the database is empty.
In my case, every hundredth of a second is worth a million $ :D (pure joke of course)
May you enlighten me?