Re: What is the cost of integrity constraints?

From: Phper <hi.steven.tu_at_gmail.com>
Date: Wed, 15 Apr 2009 21:23:17 -0700 (PDT)
Message-ID: <ca57a014-df0a-4b9b-87de-0d65d3f92fae_at_p6g2000pre.googlegroups.com>

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
> constraints!!!!!!

But we have an option. We can adopt triggers. Received on Wed Apr 15 2009 - 23:23:17 CDT