Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine

Answer Posted / rajanikanth

1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.

2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.

3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is mysql popular?

891


Which is better mysql or mssql?

931


Is there a way to see the files which are stored?

975


What is a delimiter in mysql?

1035


State the differences between mongodb and mysql.

1185


How do I remove a user from mysql?

992


How do I transfer data from one database to another in mysql?

909


What is mysql57?

924


How do I start mysql manually?

924


How can I insert images into a Mysql database?

1057


How do I edit a trigger in mysql?

898


What is truncate in mysql?

956


What is the difference between truncate and delete?

1198


Which is faster innodb or myisam?

1058


What is the difference between sql and mysql and oracle?

896