Re: Subfile initial load very slow

[J.Beckeringh@xxxxxxxxxxxxxxxxxxxxxxxxxx]

Charles,

That makes sense, if you know in advance how many records you are going to 
display, which I don't think is very common. The states of the USA, 
alright, but other than that? Apart from that it is not very clear how the 
subfile actually is extende, especially if you consider that the subfile 
size may be specified dynamically with SFLSIZ(&<fieldname). You load the 
subfile first and then tell the system its size.

We have many load-all subfile programs with an arbitrary limit of 1200 
records (SFLPAG 12 to 15; SFLSIZ dynamically specified). They load almost 
instantaneously. I recently introduced the possibilty to change the limit 
(they are PDM-like panels with the possibility to use F13 to specifiy an 
action for all items; users sometimes want to perform an action on ALL 
items); with about 5000 records it still takes less than a second (on a 
simple 515 with 8 GB memory).

I think that this day and age we can rule out subfile performance as a 
limiting factor.

Joep Beckeringh


> Charles Wilt 
>
> Bryce,
>
> Not surprising if you've used "extending subfiles (SFLSIZ > SFLPAG)"
> as recommend.  ie. You load more records when the user presses page
> down.  Example: SLFSIZ = 13, SLFPAG = 12.  Program starts and loads 12
> records.  The next 12 are loaded when the user hits page down, page
> down again and another 12 get loaded....at this point you've got 36
> records in the subfile.
>
> In this case, the OP has the subfile defined as "extending" but is
> treating it as a "load all".  This is not recommend and is often a
> source of performance issues.
>
> With a load all, you should have SLFSIZ = total # of records in the
> subfile.  Example, a subfile displaying the states of the USA should
> have SLFSIZ = 50, regardless of how many you display per page.
>
> HTH,
> Charles