Joined: 21 Dec 2010
Online Status: Offline
Posts: 15
Topic: Master file and 2 large detail files Posted: 14 Feb 2011 at 7:15am
[I may have initially posted this in the wrong section.]
I have a master file of PATIENT. I Have two other files that are both
very large - one is DOCUMENT (every interaction) and the other is
OBSERVATION (every detail observed). So, how to best setup my links to allow this to flow efficiently. (1) I want to read every PATIENT record. (2) Based on a common key field PID, I want to retrieve every DOCUMENT for the person. (3) Based on a common key field PID, I want to retrieve every OBSERVATION for the person. (4) I will then print certain things learned while reading these two activity files.
My
problem is that I can't seem to configure the Data and Links so that
this does no become a huge geometric lookup. In other words, since
there may be 20 DOCUMENTs for each person, and 200 OBSERVATIONs for each
person, it seem like for each of 2500 PATIENTs, I am doing 4000 lookups
(20x200).
Am I missing something simple so that for each of my 25000 PATIENTS there is only 220 (20+200) lookups?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum