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
- 43751 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
Who owns mysql database?
How to delete a column and add a new column to database
What is inner join in mysql?
How many rows can be inserted in mysql at a time?
Are stored procedures precompiled?
Is mysql a server or database?
Is postgresql better than mysql?
How to control the max size of a heap table?
How do I install mysql?
How do I install mysql workbench?
What are the functions in mysql?
What are the disadvantages of mysql?
Does mysql use tcp or udp?
How do I edit a stored procedure in mysql?
How do you insert a table?
