× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Joep,

Yeah, you're right that you may not know exactly how many records
you're dealing with.

The point though is that if you know you've got lots, you shouldn't be
extending it 13 records at a time. Pick 100 or maybe 1000.

Charles



On Wed, Jan 19, 2011 at 10:31 AM,
<J.Beckeringh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.