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]
