Tweeted twitter.com/#!/StackDBAs/status/186420475243663360
2 use constraint instead of restraint
source | link

Foreign key restraintsconstraints with MySQL/InnoDB

I am try to do some performance testing with varchar foreign keys vs int foreign keys and was wondering how foreign key restraintsconstraints effect performance of MySQL. I

I assume that they effect inserted/updates to a degree however I am not to worried about that in my testing. I was wonderinwondering if they effect SELECT statements and if they effect data/index size?

Foreign key restraints with MySQL/InnoDB

I am try to do some performance testing with varchar foreign keys vs int foreign keys and was wondering how foreign key restraints effect performance of MySQL. I assume that they effect inserted/updates to a degree however I am not to worried about that in my testing. I was wonderin if they effect SELECT statements and if they effect data/index size?

Foreign key constraints with MySQL/InnoDB

I am try to do some performance testing with varchar foreign keys vs int foreign keys and was wondering how foreign key constraints effect performance of MySQL.

I assume that they effect inserted/updates to a degree however I am not to worried about that in my testing. I was wondering if they effect SELECT statements and if they effect data/index size?

1
source | link

Foreign key restraints with MySQL/InnoDB

I am try to do some performance testing with varchar foreign keys vs int foreign keys and was wondering how foreign key restraints effect performance of MySQL. I assume that they effect inserted/updates to a degree however I am not to worried about that in my testing. I was wonderin if they effect SELECT statements and if they effect data/index size?