Faster one-InnoDB or MyISAM?

[Guwas]

Hi there,
Someone told me that MyISAM is fastest for any case of a 'select' statements, but i think if the key/index has some properties, InnoDB is faster than MyISAM, Who is right at this point?
Thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[evy]

Generally, InnoDB uses primary key clustered index, as a result the rows are sorted according to the primary key, but reading the table order by the primary key, it could be faster. Retrieving rows within a range of primary key values could be faster too sometimes, since the rows are located close together, possibly less disk read. And, InnoDB caches both data and index in the buffer pool, whereas MyISAM only caches the index in the key buffer. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[pumice]

Innodb is faster and is good for high traffic DB as per my view -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --