Interested to Buy Any Domain ? << Click Here >> for more details...
Explain advantages of MyISAM over InnoDB?
- 1 Answers
- 6446 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is pdo connection?
What is difference between mysql mysqli and pdo?
How do I know if mysql is running on windows?
How to store binary data in mysql?
What storage engines are used in MySQL?
How do I truncate all tables in mysql?
Write a command with which mysql table can be repaired
What is the full meaning of mysql?
What is the use of mysqli_connect in php?
why we are join a tow table
How do I install and use mysql?
What is mvcc in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
