myIsam,InnoDB and more,what is the difference?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
saumya
Forum Contributor
Posts: 193
Joined: Sun Jan 30, 2005 10:21 pm

myIsam,InnoDB and more,what is the difference?

Post 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?
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

You can try looking at Storage Engines
saumya
Forum Contributor
Posts: 193
Joined: Sun Jan 30, 2005 10:21 pm

Post by saumya »

thanks a lot.
bg
Forum Contributor
Posts: 157
Joined: Fri Sep 12, 2003 11:01 am

Post 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.
saumya
Forum Contributor
Posts: 193
Joined: Sun Jan 30, 2005 10:21 pm

Post 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
Post Reply