Re: What is the cost of integrity constraints?
From: Mladen Gogala <gogala.mladen_at_bogus.email.com>
Date: Wed, 15 Apr 2009 07:04:14 +0000 (UTC)
Message-ID: <gs40te$q75$2_at_solani.org>
Na Tue, 14 Apr 2009 21:13:30 -0700, Phper napisao:
Date: Wed, 15 Apr 2009 07:04:14 +0000 (UTC)
Message-ID: <gs40te$q75$2_at_solani.org>
Na Tue, 14 Apr 2009 21:13:30 -0700, Phper napisao:
> Does the database run much slower if there are many integrity
> constraints?
If you've done things correctly, your database isn't running anywhere, it's storing data. Unfortunately, databases usually cannot run. Application is what should be running but can also crawl. As for the constraints, if your application doesn't have any business rules, then constraints are unnecessary.
-- http://mgogala.freehostia.comReceived on Wed Apr 15 2009 - 02:04:14 CDT