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/mysql/en/custom-benchmarks.html
Kevin Burton <[EMAIL PROTECTED]> wrote:
>ere'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 know a FK when I see one but
>INNODB doesn't have to do any runtime checks on insert.
>
>My question is whether INNODB will be faster without them. If so by how
>much. If it's close to the speed of MyISAM then I'll be a happy camper.
>
>Thoughts?
>
>Kevin
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]