Re: Subfile initial load very slow

[Rory Hewitt <rory.hewitt@xxxxxxxxx>]

Huh. I've used load-all subfiles for years, and whilst they may not be the
most efficient (compared to page-at-a-time or extensible, for instance),
I've never seen the kind of 'first-time-only' problems that he's
experiencing. If it's slow, it's always slow. And frankly, with 3200
records, I'd expect a few seconds to laod at max. My guess is that it's a
logical that's being rebuilt or something similar.

Luckily, the fact that it takes so long means that he has the opportunity to
check it out. What I would do is as follows:

1. Open 2 green-screen sessions (jobs)
2. In job 1, call the program
3. In job 2, do a WRKJOB on job 2. Check out options 14 (Open files), 15
(File overrides) and 11 (Call stack). With option 14, use F11 (Display I/O
details) and press F5 repeatedly. With option 11, use F10 repeatedly to see
what procedure is being called.

You might need to do the above processing several times (ending job 1
between runs, so it's always the first-time through). Perhaps he will find
out that there is some sort of low-level file processing going on which is
slowing things down.

Rory

On Tue, Jan 18, 2011 at 2:49 PM, Mark Murphy/STAR BASE Consulting Inc. <
mmurphy@xxxxxxxxxxxxxxx> wrote:

> Sounds like one of the top two answers to me as well.  The other top answer
> is to just load one page at a time and let the subfile expand as the user
> presses page down.  Neither are very hard to do.  Not to be confused with
> "Page at a Time" which Gary proposed but rightly said was a big change.
>  Page at a time does not use an extensible subfile which the OP already said
> he has.  Sounds like he is loading the whole subfile all at once.
>
> Mark Murphy
> STAR BASE Consulting, Inc.
> mmurphy@xxxxxxxxxxxxxxx