Hello.
Usually only benchmarks will show a real picture
for you. Create foreign keys, perform some tests. Then
temporary disable FKs using SET FOREIGN_KEY_CHECKS=0 and
repeat the performance measurement. Super Smack is a good
tool for such kind of analysis. See:
http://dev.mysql.com/doc/
Here's some thing I've been thinking about.
I want to use INNODB without FKs. I don't need or want referential integrity
in my app (due to a schema and performance issue).
Basically I just create FKs in my OR layer and my app enforces the rules.
The column is still an _ID column so I visually k