Re: Subfile initial load very slow

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