Interested to Buy Any Domain ? << Click Here >> for more details...
Explain advantages of MyISAM over InnoDB?
- 1 Answers
- 6545 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 the purpose of -> in the mysql terminal?
What are the advantages and disadvantages of MySQL?
how to Return total number of rows.
What are the difference between and myisam and innodb?
What are the technical specifications of mysql?
What are mysql queries?
What is mysql gpl?
What are the nonstandard string types?
How to write optimized query in mysql?
How can we optimize stored procedure?
What is a simple query?
Can we store images in mysql database?
-
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)
