HP3000-L Archives

November 2003, Week 2

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:
Ken Robertson <[log in to unmask]>
Reply To:
Ken Robertson <[log in to unmask]>
Date:
Tue, 11 Nov 2003 11:12:33 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (31 lines)
Indeed, a DBPUT/DBGET will always return the records in the order
that they were written.
There are some other issues that you may need to take into consideration...

Other processes are likely accessing that dataset, and may even be adding
to the chain that you are writing.  Depending on your locking strategy,
your program's records will be inserted in chronological order, but may be
interspersed with records from another process!

Consider also that although the records' chains will be in order, the
records may not necessarily be physically next to each other.  IMAGE used
to try and use the DELETE chain - and this is probably still the case - and
again other processes may be deleting and adding records at the same time
that your program is doing its magic.

A simple question with a complex answer. Hm.
Product Specialist Consultant
Speedware Support
Web: www.speedware.com
Tel: 1-800-361-6782 / 514-747-9494
UK: 0.800.96.77.14
"Building Customer Loyalty Through Excellence in Customer Service"

**************** Cookie of the day *********************************
Before you criticize someone, you should walk a mile in their shoes. That
way, when you criticize them, you're a mile away and you have their shoes.
********************************************************************

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

ATOM RSS1 RSS2