Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amith
Much more conservative approach to disk space management -
each MyISAM table is stored in a separate file, which could
be compressed then with myisamchk if needed. With InnoDB
the tables are stored in tablespace, and not much further
optimization is possible. All data except for TEXT and BLOB
can occupy 8,000 bytes at most. No full text indexing is
available for InnoDB. TRhe COUNT(*)s execute slower than in
MyISAM due to tablespace complexity.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
What is heap table?
Can mysql and mariadb coexist?
Why is the basic difference between left join, right join and inner join?
Will mysql remain free?
Where does mysql store data?
What is the use of concat() in mysql?
Does facebook still use mysql?
What is the use of count function in mysql?
What are the indexes in mysql?
What is mysql url?
How to connect html form to mysql database using php?
What is default schema in mysql?
What is “i_am_a_dump” flag in mysql?
What is localhost in mysql?
