RE: accessing the records in a history file

["Mark A. Manske" <mmanske@xxxxxxxxxxxxxxxxxx>]

Don't tell management this(becaue it will appear you have removed records)
Split up the file, create LFs over date,
change pgms/qrys accessing file to go to proper one(s)
depending on selection criteria.

We have similar issue here, sales history detail files
by year, each year with from 13 million to 15 million records
and we are still on an "olde" 620 with lots of dasd...

Development may take longer due to accessing multiple files,
but run time will drop drastically "if" they are looking at
say only one year.


Just my two cents....

HTH

Mark A. Manske
[mailto:mmanske@minter-weisman.com]
Sr. Project Lead
Minter-Weisman



-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of booth@martinvt.com
Sent: Thursday, December 21, 2000 10:44 AM
To: midrange-l@midrange.com
Subject: accessing the records in a history file


I'd like some insight from folks on this scenario:  There is a history
file of records dating from 1994.  Records are added each day and now
there are 3.6 million records in the file.  The odds of anyone going back
to look up something in 1994 are slim but management won't purge any
records.  Obviously the newest records are at the end of the file.  All of
the logicals have the customer ID number as the first key. One logical has
a key of the customer ID and then date and time.

Each business day there is at least one and sometimes five or more reports
written for all activity during some recent time period (a workshift, a
day, a week, whatever).

This process is becoming a performance pig; additionally there is a need
for more function.   What sorts of suggestions do you people see as
possible enhancements to this?  SQLRPGLE? OPNQRYF? a new Logical on date
and time alone? #GSORT?

Any suggestions are appreciated.  thanks in advance.


_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________
+---
| 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
+---

+---
| 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
+---