Re: What is the cost of integrity constraints?

From: <johnbhurley_at_sbcglobal.net>
Date: Wed, 15 Apr 2009 05:27:14 -0700 (PDT)
Message-ID: <f1749d82-83e7-4d19-82f2-0eaa0092869f_at_c9g2000yqm.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?

This is really something that can best be demonstrated with specific examples and benchmark testing on a system with data that is meaningful to you.

Lots of people have done write-ups and have canned examples showing the trade-offs involved if you spend some time searching around for stuff like that is is there already.

But again ... they will be canned examples ... and perhaps not meaningful to your systems and your data.

You learn the most when you are benchmarking stuff that you created on your own. Received on Wed Apr 15 2009 - 07:27:14 CDT