Interested to Buy Any Domain ? << Click Here >> for more details...
Explain advantages of MyISAM over InnoDB?
- 1 Answers
- 6433 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 |
Does adding an index lock a table?
Is oracle mysql free?
What is difference between microsoft sql and mysql?
How to display odd rows in student table in mysql?
which version of mysql can't support stored procedure??
What is the difference between char and varchar?
What is delimiter in mysql stored procedure?
Is microsoft sql same as mysql?
What are the two types of queries?
how we can use more then one primary key in Single Table
How do I edit a table in mysql workbench?
What is general log 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)
