Post reply

The Pitfalls of Foreign Keys

  • March 5, 2007 at 7:27 am

    #693084

    Indeed.  Here's the single agreeable point made in this entire discussion, and it was gleefully overlooked by all but one.

    Ok, now two.  Whenever you have to consider the potentially dangerous approach (IMHO) to squeeze performance out of X amount of hardware vs getting more hardware to do it the RDBMS 101 way, your decision is placed squarely on the business.  Your preference is merely another variable in the equation.

    Hopefully, they get it right.

     

  • March 26, 2009 at 12:32 pm

    #966954

    Clearly written article. You just saved me a bunch of testing.

    I'm deleting a M records from a table that is a FK to other tables that are equally large. This totally explains why it is taking forever.

Viewing 2 posts - 46 through 46 (of 46 total)

You must be logged in to reply to this topic. Login to reply