RE: subfile loading question!

["Randy Robb" <rwrobb@xxxxxxxxxxxx>]

I agree with the other comments: the problem is not in your subfile.
Try looking at the step-by-step logic used to select the next record.
I've got a hunch it's not just a simple read, but that some type of
selection process is happening.  Perhaps a subroutine tests each record
before making it available to the subfile, or maybe an embedded SQL?  What
about a logical file with Dynamic keys?

Since it's an interactive program, why not use STRISDB?
Once the source is displayed, you can:
* Position to a line of code by typing it in on the "command line"
* Set a breakpoint with F6
* Display a program variable by putting the cursor on the field name and
pressing F11
* Step through the code, line by line, using F5
* Run to the next breakpoint using F17

You can also use STRISDB on batch programs.
* Specify INVPGM(*CMD)
* Specify CMD(CALL MYPROG PARM(any parms needed))

By the way, change UPDPROD(*YES) to avoid problems with update files, but
you'd better be doing this against test files.
(You're debugging this in a development, not against production, right?)


-----Original Message-----
From:   owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]
On Behalf Of jigna desai
Sent:   Saturday, August 14, 1999 3:47 PM
To:     MIDRANGE-L@midrange.com
Subject:        subfile loading question!


Hi all,
   i have a situation with a subfile pgm where the SUBSIZ is 6 & SUBPAG
is 5 .Indicator 85 is rolldown indicator & 84 is rollup.Records r
read,written & displayed 5 at a time with each subsequent pagedown
which is handled in the pgm via *IN85.Pageup has no logic since after 3
pagedowns when 20 records r displayed -the previous 15 records r
already in the subfile & need not be accessed again.
     However,the problem is our customer record file being very very
large comprising of millions of records
it causes a performance issue since the process is very slow.To handle
pagedown -- i think there is no better method than used in the pgm so
what then, should i do so that the process is not slow ?

Pl let me know if there is any other way to handle this & improve
performance time.
Thanx for ur help in advance.


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---