On Wed, 11 Feb 2004, Christopher Browne wrote:
> A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jodi Kanter) wrote:
> > Do constraints effect performance significantly?
>
> They would be expected to provide a significant enhancement to
> performance over:
> a) Firing triggers,
>
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jodi Kanter) wrote:
> Do constraints effect performance significantly?
They would be expected to provide a significant enhancement to
performance over:
a) Firing triggers,
b) Firing rules, and
c) Forcing the application to validate
On Wed, 11 Feb 2004, Jodi Kanter wrote:
> Do constraints effect performance significantly?
That depends.
Foreign key constraints on int4 columns or int8 columns (matching of
course) are usually quite fast.
FK constraints on non-int (numeric, text, etc...) tend to be slower.
check constraints
Do constraints effect performance significantly?
Thanks
Jodi
--
___
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
[EMAIL PROTECTED]