MySQL - InnoDB vs MyISAM

[Marc Vanzegbroeck]

Hi,

I'm using MySQL with ADO. When I create my tables on a MySQL-server, I create tables with type InnoDB.

Now I'm testing to connect to MySQL on my website. My host is using cPanel. It's working very nice. The only difference is that my program is creating tables of type MyISAM instead of InnoDB.
What is the difference? What is the best? Whow can I change the type?

[thefull]

MyISAM is very fast , but not have "referential integrity" and support for "transactions".


http://stackoverflow.com/questions/1261 ... -vs-innodb

Spanish
http://www.arsys.info/programacion/myis ... nto-mysql/