below are the practical statistics to understand the database storage engines and its advantages and disadvantage
i have created the PHP scripts which inserts the 5000 rows inside the mysql table.
in case of INNODB
we can Insert 130-250 rows at a time only [it might depend on the processor of your server/ computer]
after inserting almost 2000 rows by script [please note for inserting 2000 rows through scripts i have to manipulate script for arranging and inserting them in order]
now i applied Select query on that table , it has taken 0.06 sec to fetch all the record
in case of MyISAM
we can directly insert the 2000-5000 rows inside the table
to select 2000 rows it will take around 0.005 sec
From the above statistics we feel that MyISAM is more better than InnoDB but there is oe major disadvantage in large amount of data………………that we can not apply proper indexing to MyISAM table…………which is very bad scenario.