[GLLUG] Is there any sane reason to do this? (Database question.)

John G Walker johngeoffreywalker at yahoo.co.uk
Wed Oct 8 12:54:39 UTC 2014

On Wed, 8 Oct 2014 13:38:23 +0100 James Courtier-Dutton
<james.dutton at gmail.com> wrote:

> There are all sorts of design reasons for laying out schema in
> particular ways, normally tables like this are to reduce duplication
> of data in the database, but there is always a trade off between less
> duplication vs. performance vs gap locking problems.

One reason for doing might be that a date associated with a particular
key might change. One change to the database would then change all
instances of the date.

From what the OP wrote, this doesn't appear to be the case here. But it
would seem likely that the original designer had been taught that
technique without understanding the reason for it,

 All the best,

More information about the GLLUG mailing list