Thanks to all for the quick and thorough info.
Since I only have Adager Model 1 I can't add the sort easily (without
dbunload/dbreload and I haven't done that since ????).
I called Adager (should have done that first) and got the procedure down for
repacking sorted and then fixing the path.  So I guess I have another
overnight job to schedule (albeit a short one this data set is 8200 records
and 377 Kb).

Bill Grefe
[log in to unmask]

-----Original Message-----
From:   HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Mike Hornsby
Sent:   Wednesday, March 08, 2000 10:52 AM
To:     [log in to unmask]
Subject:        Re: sorting image data

> Wyell's point is well taken re: performance hits on multiple sorted paths.
> Image will have to do yeoman's work to sort each of the paths for each
put,
> delete or update.

The performance issue would only exist if CATALOGUE-NUMBER is NOT added in
ascending sequence.

If the new entry's sort item is greater than the last entry's sort item in
the chain then very little additional work is required as the new entry will
simply become the last entry on the chain.

Cordially,

Mike Hornsby
Co-founder/Chief Technical Officer
Beechglen Development Inc. (www.beechglen.com)
5576 Glenway Ave.
Cincinnati, Ohio 45238

Voice (513) 922-0509
Fax (513) 347-2834
Email [log in to unmask]