HP3000-L Archives

February 2006, Week 1

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:
IMAGE sort key
From:
Kent Wallace <[log in to unmask]>
Reply To:
Kent Wallace <[log in to unmask]>
Date:
Wed, 1 Feb 2006 08:39:52 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (50 lines) 
I (we) am loading a lot of data into a detail data set in IMAGE with a
sort key.  Do I presort the data by the sort key only?  Or do I presort
by the Automatic key then the sort key?

 

 

As in:

 

   Entry:                     Offset

      BP-EXPLODE#          X10     1  (!BP-EXPLODE-A(PRIORITY))

      BP-BENEFIT           X10    11  (BP-BENEFIT-A)

      COMPONENT            X4     21

      RIDER-TITLE          X8     25

      YMDEFF               X8     33

      YMDEND               X8     41

      PRIORITY             X2     49

 

I know this really improve performance.

 

Thanks

Kent Wallace

 

 

 

 


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

ATOM RSS1 RSS2