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

which function used to get the file name in php?

5 Answers  


How can you tell if a number is even or odd without using any condition or loop?

0 Answers  


What are the methods useful for method overloading?

0 Answers  


What are the popular frameworks in php?

0 Answers  


What is the difference between php and java?

0 Answers  






What advance thing in php7?

0 Answers  


How many ways we can pass the variable through the navigation between the pages?

7 Answers  


What is mvc? Why its been used?

0 Answers  


How to execute an sql query? How to fetch its result?

0 Answers  


Is it possible to extend the execution time of a php script?

0 Answers  


What are the differences between Get and post methods in form submitting, give the case where we can use get and we can use post methods?

11 Answers   HCL, Rushmore Consultancy, Thursday Technology,


we have two tables first one is EMPLOYEE having EmpID, EmpNAME, Second table is SALARY table having id, salary Write a query to get name of those person who having more than 10000$ salary

3 Answers   Net Solution,


Categories