gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Observations & questions about GNUmed
Date: Mon, 8 Oct 2007 07:32:55 +0200
User-agent: Mutt/1.5.16 (2007-06-11)

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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]