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 apache and php?

0 Answers  


how can i disable multiple user in the same password in my website using any scripts

1 Answers  


What type of headers have to be added in the mail function to attach a file?

0 Answers  


i got 2 year backs in my MCA,i am 28 year guy, presently learning PHP, can i get the job & on facing the interview wht i will answer out for that?? (experience in as a 1.5yr System analyst after graduation)

0 Answers  


how long a default session stay in php?

8 Answers  


What is beforeRender() used?

0 Answers   HCL,


Which is faster for or foreach?

0 Answers  


What version of php do I have windows?

0 Answers  


How to take a substring from a given string?

0 Answers  


How is it possible to remove escape characters from a string?

0 Answers  


Is there any function to find repeated value in an array? What is w2 standard

1 Answers  


Specify pre-defined classes in php ?

1 Answers  


Categories