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
- 3664 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 you can use regular expression for in mysql? Support your answer with an example?
Explain csv tables.
What is a crosstab query?
What is the purpose of using a heap table?
How database are managed?
Why is mysql used?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
Does mysql use tcp or udp?
What is difference between microsoft sql and mysql?
What does "i_am_a_dummy flag" do in mysql?
What are the technical features of MySQL?
Write a command to list all databases in mysql?
How can you increase the performance of mysql select query?
How do I get a list of table names in mysql?
Which is faster innodb or myisam?
