Accessing files in QUIZ

[MattO1@aol.com]

In a message dated 3/8/99 8:04:43 PM EST, tony_knowles@ferntree.co.nz writes:

<< I am trying to determine which is the best way to access a single record
 file by specified key value in QUIZ ...
 
 (1) access file a &
       link ("abc") to key-b of file b &
       link key-a of file a to key-c of file c
 
 (2) access file a &
       link key-a of file a to key-c of file c &
       link ("abc") to key-b of file b
 
 In other words, only one record is being retrieved from file b which has no
 relationship to either file a or file c. I have done some (inconclusive)
 testing, anyone know which is more efficient, or doesn't it matter????
 
 Tony Knowles     tony_knowles@ferntree.co.nz
                  ajk@ihug.co.nz
  >>

My guess is, it won't make a bit of difference.  It the key is unique, Quiz
will read the record once on the first record complex and simply retain it in
memory for the rest of the run.  Now, this works only if you've actually TOLD
Quiz (in the dictionary) that it is a unique key.  If the key is declared as
repeating, but there is only one record actually in the file , then I suspect
Access statement 1 will be faster.

Matt Ohmes
Matto1@AOL.COm
Matt.Ohmes@Cognos.Com
"Don't trust Matt! He doesn't speak for Cognos!  In fact, we refuse to even
acknowledge he works for COGNOS!!!"
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.