Re: What is the cost of integrity constraints?
From: <gareth_at_jamms.org>
Date: Wed, 15 Apr 2009 04:32:21 -0700 (PDT)
Message-ID: <ae3ce6c8-77c3-420b-99fe-0bcefbd67556_at_o6g2000yql.googlegroups.com>
On 15 Apr, 05:13, Phper <hi.steven..._at_gmail.com> wrote:
> Does the database run much slower if there are many integrity
> constraints?
Date: Wed, 15 Apr 2009 04:32:21 -0700 (PDT)
Message-ID: <ae3ce6c8-77c3-420b-99fe-0bcefbd67556_at_o6g2000yql.googlegroups.com>
On 15 Apr, 05:13, Phper <hi.steven..._at_gmail.com> wrote:
> Does the database run much slower if there are many integrity
> constraints?
Of course there is an overhead associated with constraints. Just like your car uses more fuel when the engine is running!
Let the database do what it's good at: maintaining your data integrity. Without that, you have nothing.
HTH -g Received on Wed Apr 15 2009 - 06:32:21 CDT