RE: Access Key for a Sub File ?

[david.kahn@xxxxxxxxxxxxxxxxxx]

Joel Fritz <JFritz@sharperimage.com> wrote:

>My real question is:  OK, you've got a lot of records in your subfile,
>enough to warrent a binary search (a cool idea, I hadn't thought of doing
it
>in a subfile).  Is there a significant performance difference between
doing
>this in an array and a subfile?

Probably not. The average number of subfile accesses compares favourably
with loading the next page of an expanding subfile. The array method is
fairly compute intensive. It could well pay to use a binary search on the
array, actually.

My guess is that both methods would give you an excellent response time,
especially following the horrific original subfile load, and the user
probably would not be able to tell the difference. Personally I prefer the
binary chop directly in the subfile as the array is not really necessary.

Dave Kahn, ABB Steward Ltd.


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---