topic-25150

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

MySQL - InnoDB vs MyISAM
Posted: Wed Nov 07, 2012 07:39 AM

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

Posts: 731

Joined: Fri Oct 07, 2005 07:42 AM

Re: MySQL - InnoDB vs MyISAM
Posted: Wed Nov 07, 2012 08:56 AM

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/

Saludos

Rafa Carmona ( rafa.thefullARROBAgmail.com___quitalineas__)

FiveTech Support Forums

Continue the discussion