What is the difference between InnoDb tables and MyIsam
Tables in php



What is the difference between InnoDb tables and MyIsam Tables in php..

Answer / 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

More PHP Interview Questions

What is PHP?

8 Answers  


Tell me how to find the position of the first occurrence of a substring in a string?

0 Answers  


How do you identify independent and dependent variables in regression analysis?

0 Answers  


What’s the difference between md5(), crc32() and sha1() crypto on PHP? -

2 Answers  


What are the rules for naming a php variable?

0 Answers  






What is the scope of a variable defined in a function?

0 Answers  


What is member variable?

0 Answers  


Where php basically used?

0 Answers  


Why is php so popular?

0 Answers  


What does mysqli_query return?

0 Answers  


What is MIME?

2 Answers  


What is config file in php?

0 Answers  


Categories