Re: [Gnumed-devel] Observations & questions about GNUmed

[Karsten Hilbert]

On Sun, Oct 07, 2007 at 09:04:01PM -0400, Dave Cramer wrote:

> That is more efficient, however postgresql will still check the integrity 
> of the data. Now that I think of it, if you look at the dumps postgresql 
> creates, it applies the FK constraint after inserting all the data.
>
> Note: I'm not suggesting that you drop them, I'm just suggesting that 
> sometimes compromises  must be made between the "right" answer and the 
> practical solution.
Well, we haven't yet encountered a scenario where things
were too slow due to FKs so the decision wasn't necessary
yet.

There's also the first rule of optimization: Don't.
The second: Don't yet.

We applied it so far.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346