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 overloading and overriding in oop?

0 Answers  


What should we do to be able to export data into an excel file?

0 Answers  


What is htaccess in php?

0 Answers  


What is lamp in php?

0 Answers  


Which operator is used to concatenate two strings in PHP?

0 Answers  






Explain php split() function.

0 Answers  


How to open a file for reading?

0 Answers  


How do you access a get requests url parameter with php?

0 Answers  


Why do we use csrf token?

0 Answers  


What is indexing how many types?

3 Answers   DLF, Infosys, Net Solution, Vcare,


class Database { public static $_instance; public static function getInstance() { if(!isset(self::$_instance)) self::$_instance = new Database(DB_SERVER, DB_USER, DB_PASS, DB_NAME); print_r(self::$_instance); return self::$_instance; } } can any one explain "self::$_instance = new Database(DB_SERVER, DB_USER, DB_PASS, DB_NAME);" this line

1 Answers  


Tell us how to create an array of a group of items inside an html form?

0 Answers  


Categories