Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between InnoDB and MyIsam
- 1 Answers
- 9350 Views
- Brain Technosys, IBM, TCS, TLI Software, Wipro, I also Faced
- E-Mail Answers
Answer / sanjoy ganguly
* The big difference between MySQL Table Type MyISAM and
InnoDB is that InnoDB supports transaction
* InnoDB supports some newer features: Transactions,
row-level locking, foreign keys
* InnoDB is for high volume, high performance
Most people use MyISAM if they need speed and InnoDB for
data integrity. You can use more than one or any combination
of these table types in your database. Remember to asses the
needs of your application before building it. Even though
MyISAM is faster than InnoDB in the MySQL world, InnoDB is
fast compared to any database engine.With InnoDB you get
transactions, speed and integrity three features not usually
used in the same sentence.
InnoDB has been designed for maximum performance when
processing large data volumes. Its CPU efficiency is
probably not matched by any other disk-based relational
database engine.
Fully integrated with MySQL Server, the InnoDB storage
engine maintains its own buffer pool for caching data and
indexes in main memory. InnoDB stores its tables and indexes
in a tablespace, which may consist of several files (or raw
disk partitions). This is different from, for example,
MyISAM tables where each table is stored using separate
files. InnoDB tables can be of any size even on operating
systems where file size is limited to 2GB.
| Is This Answer Correct ? | 36 Yes | 1 No |
what is interface in php? how it is use?
10 Answers Infosys, PHP, Times, Torque Infotech, Wipro,
How to return ascii value of character in php?
What is php good for?
Can we use onclick in submit button?
How do I know my xampp version?
When to use inquire vs enquire?
How session works (internal processing of session) ?
3 Answers ASD Lab, IPSR Solutions,
How i can integrate merchant payment get way in zen cart? in php? plz help me
1 Answers BA Continnum Solutions,
Which is better python or php?
Can we extend final class in php?
How is csrf token generated?
I am writing an application in php that outputs a printable version of driving directions. It contains some long sentences, and I am a neat freak, and would like to make sure that no line exceeds 50 characters. How do I accomplish that with php?
PHP 
