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

How to create an array in php?

0 Answers  


How many types of php are there?

0 Answers  


What are the current versions of apache, PHP, and mysql?

21 Answers  


What is difference between array_merge and array_combine?

0 Answers  


What is the use of session and cookies in php?

0 Answers  






What is the difference between $argv and $argc? Give example?

0 Answers  


Is php a float?

0 Answers  


Explain about getters and setters in php?

0 Answers  


How to declare an array in php?

0 Answers  


How do you get the Browser information?

3 Answers   Life Infotech,


What is full form of php? Who is the father or inventor of php?

0 Answers  


What are the advantages and disadvantages of Cascading Style Sheets?

1 Answers  


Categories