MyISAM vs InnoDB
I keep reading how InnoDB is faster than MyISAM. I wanted to find out myself.
When I was using a forloop in PHP to fill my MySQL test database with 100,000 numbers using PDO driver.
|a| +-+ |0| |1| |2| |3| |4| ... |99999|
I find out that with InnoDB it went 95 records per second. After a while I stopped my script cause going to 100,000 is just going to take too long. Changing my table to MyISAM and re-running the script made a whopping 6000 records per second! Both tables have no indexes.
How is it that the internet is claiming InnoDB is faster than MyISAM. Could it be that PDO is bottlenecking InnoDB?