MySQL Forums
Forum List  »  Partitioning

Re: Foreign key constraints with partitioning
Posted by: Phil Hildebrand
Date: March 31, 2009 11:45PM

It's likely not much more overhead then validating a FK constraint, if you think about it. ( A FK constraint still has to look in the Foreign table/pk index for the associated record before allowing an insert/delete)

If you partition the index that the trigger inserts into to check it, then that will likely help as well.

But yea, there is overhead with the the trigger, so you'd likely have to run a set of your inserts before (without partitions, with fk's) and compare it to after (with partitions, with triggers for fk's) and see. It likely depends on the number of inserts/deletes per second your app does.

Options: ReplyQuote

Written By
Re: Foreign key constraints with partitioning
March 31, 2009 11:45PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.