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 the main difference between myisam and innodb

Answer Posted / ranganath

Other differences are :

1. innodb requires more RAM than mysiam
2. myisam relies on OS for caching while innodb caches with
in the engine itself.

3. Most preffered is innodb because

- Transaction safe
-It has commit, rollback, and crash recovery capabailities
- Innodb is designed for maximum performance when processing
large volumes of data.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I rename a table in mysql?

956


Can we write pl sql mysql?

927


What is sharding in mysql?

956


What is append query?

901


Does mysql use t sql?

953


Which command is used to view the content of the table in mysql?

898


Is mysql a free database?

926


What is a trigger? How you can create a trigger in mysql?

884


Can you tell what are various ways to create an index?

860


How to get a list of all tables in a database?

1034


What is current version of mysql?

953


What is max connection in mysql?

908


What is int unsigned?

921


Is pdo faster than mysqli?

877


How to delete a column and add a new column to database

926