What is the difference between InnoDb tables and MyIsam
Tables in php
Answer Posted / rameshfromind
InnoDB
=======
InnoDB is commonly viewed as anything but performant,
especially when compared to MyISAM. Many actually call it
slow. This view is mostly supported by old facts and
mis-information. In reality, you would be very hard-pressed
to find a current, production-quality MySQL Database Engine
with the CPU efficiency of InnoDB. It has its performance
"quirks" and there are definitely workloads for which it is
not optimal, but for standard OLTP (Online Transaction
Processing) loads, it is tough to find a better, safer fit.
1.Performance
2.Concurrency
3.Reliability
4.Data Security
MyISAM
======
1.Simplicity
2.Optimization
3.Resource Usage
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a query in php?
What is framework in php for beginners?
Do you know how can we check the value of a given variable is a number?
What exactly is PHP?
Tools used for drawing er diagrams?
What is isset in php form?
What is php session start?
How do you remove whitespace from the beginning and end of a $string variable?
How many escape sequences are recognized in single-quoted strings?
What is the function in PHP do not return a timestamp?
Explain php split() function.
What is html used for?
How to open a file for writing?
What is symfony php?
Which have the fastest execution between mysql_fetch_array() and mysql_fetch_assoc()