Interested to Buy Any Domain ? << Click Here >> for more details...
Explain advantages of MyISAM over InnoDB?
- 1 Answers
- 6414 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 |
How to create a new table in mysql?
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 Answers E2 Solutions, Tesco,
What is memory table in mysql?
Is mysql a backend?
Why myisam is faster than innodb?
how to repair a table in mysql?
What is mysql in dbms?
How to create table show example
What is the usage of ENUMs in MySQL?
What are views in mysql?
What does it mean to be case sensitive?
Does mysql use sql?
-
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)
