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

Is mysql a dbms?

896


How do I find the database name in mysql?

962


What is a join in mysql?

919


Can you tell which of the following where clauses is faster?

917


How do I stop a mysql command?

999


How do I flush privileges in mysql?

1015


What is append query?

921


What is the storage engine for mysql?

966


Is mysql frontend or backend?

914


How to use like conditions?

993


How we can get distinct columns values in mysql?

1091


What are the differences between binary and varbinary?

1067


How many sql ddl commands are supported by 'mysql'?

1141


What is truncate command?

958


Is mysql a framework?

936