David Tangye 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.
I seriously doubt that anyone is pushing PostgreSQL hard enough with LedgerSMB to see the degradation caused by a fk. If they are, it is likely the fault of LedgerSMB (and its parent) then PostgreSQL itself.
Joshua D. Drake
------------------------------------------------------------------------- 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
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/