Re: Foreign key constraint added to acc_trans

["Chris Travers" <..hidden..>]

Hi David;

A lot of people use foreign key constraints in their production
databases only during the testing phase and then disable them when
they suffer performance problems.  I don't really have an issue if
people want to disable the foreign key constraints after the fact (it
is their risk), but I would rather take the approach of "locked down
by default."

Also, again, this is just a heads-up.  If people really are that
worried about performance they can always disable the constraint but
that isn't going to make it into our distribution :-)

Best Wishes,
Chris Travers

On 9/15/06, David Tangye <..hidden..> wrote:
> On Fri, 2006-09-15 at 08:50 -0700, Chris Travers wrote:
> > I know there are often
> > concerns about the performance implications of foreign key
> > constraints, so I want to give people a heads up.
> Its a choice between add FKs and accepting possible performance hits, or
> not having them and risking data corruption. Guess which I would pick
> every time.
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel