Re: What is the cost of integrity constraints?
Date: Thu, 16 Apr 2009 07:32:16 +0200
On Wed, 15 Apr 2009 21:23:17 -0700 (PDT), Phper <hi.steven.tu_at_gmail.com> wrote:
>On Apr 15, 12:50 pm, roelof.streeks..._at_gmail.com wrote:
>> On Apr 15, 12:13 am, Phper <hi.steven..._at_gmail.com> wrote:
>> > Does the database run much slower if there are many integrity
>> > constraints?
>> Yes it runs slower.
>> But the question you ask is WRONG!!
>> Most databases do more reads then writes so why would you optimise for
>> inserts instead of guaranteeing that the data is correct.
>> Most business people value correct data over speed of inserts.
>> Thanks roelof.
>> PS One of the corner stones of Relational Databases theory is having
>But we have an option. We can adopt triggers.
Which is about 8 times less efficient as constraints and triggers are
This is not an option. This just one of the ways to end up with an unscalable app.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Apr 16 2009 - 00:32:16 CDT