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
- 1 Answers
- 3744 Views
- I also Faced
- E-Mail Answers
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
What is the default port of mysql server?
What are triggers in mysql?
What is the maximum number of columns per table?
What are the functions used to encrypt and decrypt the data present in mysql?
Why do we use mysql?
using primary can we relate two table, with out foreign key?
What are the types of database engines available in mysql?
Is mysql query case sensitive?
What is a session in mysql?
Is oracle mysql free?
What is trigger in mysql?
What is 'mysqlcheck'?
What is relational database in mysql?
Is mysql a backend?
Is null in mysql?
