HP3000-L Archives

January 2002, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Wirt Atmar <[log in to unmask]>
Reply To:
Date:
Sat, 19 Jan 2002 14:23:20 EST
Content-Type:
text/plain
Parts/Attachments:
text/plain (27 lines)
Roy relates the royally right stuff when he writes:

> However, if I were you, I wouldn't start from here :-)
>
>  It is seldom a good idea to create Image Master datasets, except maybe
>  for codes and other unique non-linked items.
>
>  Three reasons: (i) the sort of thing you have found above; (ii) you have
>  to lock the entire dataset when adding or deleting entries - you can't
>  use a record level lock; (iii) you may have to deal with migrating
>  secondaries[1].
>
>  You will not find this advice in the Image manual :-(
>
>  Instead, create your datasets as Detail datasets and use Automatic
>  Masters to hold the ends of your key chains (so to speak).

I'll even go further than Roy. I've long ago come to the conclusion that it's
never a good idea to use Manual Masters. Databases, if they are to be
designed for long-term efficiencies and maintainability, should only be
composed of Detail Datasets with Automatic Masters.

Wirt Atmar

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2