Re: What is the cost of integrity constraints?

From: <roelof.streekstra_at_gmail.com>
Date: Tue, 14 Apr 2009 21:50:32 -0700 (PDT)
Message-ID: <16ebef52-84cd-4707-a172-a69ef1fef02c_at_r33g2000yqn.googlegroups.com>

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!!!!!! Received on Tue Apr 14 2009 - 23:50:32 CDT