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


Please Help Members By Posting Answers For Below Questions

What are the difference between abstract class and interface in oops?

500


What are the advantages of php?

526


What is the purpose of the php empty function?

488


Can the value of a constant change during the script's execution?

541


What is the use of dual table in mysql?

512






What is final class and final method in php?

543


What is a php class?

532


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

484


What is an operator in php?

565


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

552


What does the arrow mean in php?

518


How is csrf token generated?

505


What is stripslashes php?

509


How to genrate report in wordpress cms

1802


How to test if a variable is an array?

555