Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database Design Question - any suggestion?

Re: Database Design Question - any suggestion?

From: Ja Lar <ingen_at_mail.her>
Date: Thu, 9 Dec 2004 23:17:17 +0100
Message-ID: <41b8cef8$0$218$edfadb0f@dread11.news.tele.dk>

"ChrisK - DBA" <cbkite_at_gmail.com> skrev i en meddelelse news:1102539703.474197.92750_at_f14g2000cwb.googlegroups.com...
>I would completely agree with this. This would force a rebuild of the
> constraint for every new product type.
Here we agree.

>I come from the type that leaves
> all checking to the application if possible. Depending on your use of
> this database, I think response time is a very important factor for
> most and check constraints can slow things down in an OLTP environment.
Here we don't. The DBMS should take care of the integrity by itself and across various applications, and performance comes second. If essential, let the application do some performance tuning eg by caching, but never switch roles. Received on Thu Dec 09 2004 - 16:17:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US