Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
- 10 Answers
- 44181 Views
- E2 Solutions, Tesco, I also Faced
- E-Mail Answers
Answer Posted / lekhraj deshmukh
There is foolowing Differences between MYISAM and InnoDB
ENGINE:-
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 ? | 79 Yes | 5 No |
Post New Answer View All Answers
What are queries used for?
What is mysql aggregate functions? Explain
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
How to shut down the server with 'mysqladmin'?
How do I edit a stored procedure in mysql?
What is sql in mysql?
What are the differences between binary and varbinary?
Is mysql good for large database?
How to show all tables with 'mysql'?
What is a join in mysql?
How to shutdown mysql server?
What is mysql and why it is used?
How to create a table?
What is difference between statement and preparedstatement?
What is longblob in mysql?
