Re: schema/db design wrt performance

On Thu, Jan 16, 2003 at 09:50:04AM -0600, Ron Johnson wrote:
>
> Could BEFORE INSERT|UPDATE|DELETE triggers perform the same
> functionality while touching only the desired records, thus
> decreasing conflict?

You can make the constraint DEFERRABLE INITIALY DEFERRED.  It helps
somewhat.  But the potential for deadlock, and the backing up, will
still happen to some degree.  It's a well-known flaw in the FK
system.  I beleive the FK implementation was mostly intended as a
proof of concept.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110