Page 1 of 1

myIsam,InnoDB and more,what is the difference?

Posted: Tue Aug 23, 2005 4:18 am
by saumya
hi all,
I am confused with the different type of databases mySql provides.What is exactly the difference between them?is there a reason why i should use one over the other?

Posted: Tue Aug 23, 2005 6:26 am
by anjanesh
You can try looking at Storage Engines

Posted: Tue Aug 23, 2005 7:29 am
by saumya
thanks a lot.

Posted: Wed Aug 24, 2005 12:48 am
by bg
i actually just starting delving into this stuff myself. I made the switch to InnoDB for my current projects database when I discovered foreign constraints, something innodb supports while myisam doesnt. For better referential integrity, go with innodb over myisam and learn constraints.

Posted: Wed Aug 24, 2005 1:38 am
by saumya
oh.ok, i will practice that.
Thats a quick great help.Otherwise i might have taken a lot of time to figure out what exactly are the points.
thank you