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 --