Re: N-to-N Model: Table Size vs Complexity

[dimitar nenchev]

Hi dudes

I always wonder for such N-to_N tables what is the better engine to use i.e.:

if we have a table

CREATE TABLE `friends` (
`userID` MEDIUMINT NOT NULL ,
`friendID` MEDIUMINT NOT NULL ,
PRIMARY KEY ( `userID` , `friendID` )
)

and we must join this table with table `users` to search users for example.
Which is better MyIsam or InnoDB
I know that InnoDB uese clustered index and it is fastter when search by PK, but in this case if the table is MyIsam is it using only the index data which may be cached also, without lookup for data in friends.MYI