I performed a test on comparing the performance of query on these three
typesof storage engines

Setup: MySQL 5 on Windows XP

Table :

t1 (
id int(11) auto increment,
txt varchar(255),
dt datetime
)

Procedures:

Insert 10000 rows of random generated data into the table, perform the
query in the type of:

Select id from t1 where id = $i

I performed the query using $i = 1 to 10000

The query is done using a SP on MySQL 5, so no connection overhead.


The results is :

MyISAM: 1.5 seconds
InnoDB: 1.0x seconds
Memory: 0.5x seconds

The result is quite interesting, as many people expect MyISAM is faster
than InnoDB.