22.02.2014, 15:01
Even if you don't use foreign key constraints InnoDB seems to be the better choice. Did a quick test just now; table with about 80,000 rows. Fetch a single result. MyISAM took 0.1476 seconds. InnoDB took 0.0236 seconds.