Re: Database Design Question - any suggestion?
Date: Thu, 9 Dec 2004 23:17:17 +0100
Message-ID: <41b8cef8$0$218$edfadb0f_at_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 - 23:17:17 CET