Subject: | |
From: | |
Reply To: | |
Date: | Mon, 10 Nov 2003 14:23:06 +0100 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Greetings from a database-illiterate.
I'm wondering how predictable chained (DBFIND and then) DBGETs is. I.e.
will the (unsorted) chain (always) be in the same order as they were
written? Initial testing shows that if I write (DBPUT) a few records to the
(unsorted) detail A, later reading (with DBFIND(master-key) and [loop]
DBGET,5) will give me the records in the same order they were written. Will
that always be true? If not, are there special circumstances for when it's
not true or is it just coincidence that they come back in the order they
were written? Will reload/structural changes to the database change this?
Am I missing something fundamental just by asking this?
The normal order of events in this process is that the master-record and
the detail-records is written *once* without changes/updates, and at some
later time they are read (and the master updated to "been read"-status)
*once*. So my first objective is to find out how predictable the reads are
(changes to DB or programs will probably be painful ;-).
tia
/per
--------------------------------------------------
Per Ostberg / [log in to unmask]
tel 08-585 812 13 / fax 08-585 877 10
mob 070-484 02 53
LabMedicin-IT, Huddinge Universitetssjukhus
C1 56 / 141 86 HUDDINGE / SWEDEN
--------------------------------------------------
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|