Foreign Key constraint

Hi All,

Foreign key constraint is implemented in MYISAM. As I read that it is supportable in innodb and innodb storage engine taking a lot of memory which is slow down the response of mysql.

There is any way to do it.


FK not supported in myisam )

Myisam takes a lots of memory too. Innodb using a different mechanism to store and retrieve data. If something using much more memory (and its not a PC game), that should mean its store more information in a very fast container and can give it back to you very fast, isn’t it?

And of course, innodb can be limited and able to eat up less memory like myisam do. And there are the clustered indexes.

Sorry but I have to say, keep learning )