Home Forums Database Design Design Ideas and Questions Foreign Key Constraints and Performace! RE: Foreign Key Constraints and Performace!

  • July 6, 2010 at 3:00 am

    #1188978

    PaulB-TheOneAndOnly (7/5/2010)

    FKs certainly add overhead but I would refrain myself of saying that FK implementation is fatal in terms of performance.

    Having said that I have seen critical, high end systems - 60K+ executions per second - where each millisecond counted then no PK/FK was defined. In this case PKs got replaced by unique indexes and RI was enforced at the app side.

    Hope this helps.

    [font="Verdana"]

    Thanks Paul,

    Do overhead of constraints is same for all CRUD Operations. Or there are some differences?

    [/font]