[AccessD] Membership File Changes

David McAfee davidmcafee at gmail.com
Thu Mar 6 19:02:03 CST 2014


<snip>
This strategy is not without detractors however, mostly "old timers" from
databases where multi-field PKs were ALWAYS used. Mostly they try to argue
that it is possible to just read the PK down in the child / grandchild /
great grandchild etc. simply by looking at the data in the multi-field PK,
which "saves your bacon" when orphans creep in and so forth.  Additionally
the "values" can often be pulled for reporting and the like, without
requiring joins back up the chain.  Both are true, but not (IMO) make up
for the overhead and headaches that multi-field PKs bring with them.
</snip>

John, I was recently called an old timer because I insisted on using
autonumber integer PK for some of our new designs.
The young whipper snapper said that's the "old way" of doing things, and is
very anal about using GUIDS and multi-field PKs.

I know GUIDs have their place, but he just doesn't get it. I love how my
stuff runs so much faster, even with joins. :)

D


More information about the AccessD mailing list