Re: Load all subfile

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I am glad you have such a static database, that nothing changes from the
beginning of the day, no new records are added etc etc!




"Booth Martin" <Booth@MartinVT.com>
Sent by: rpg400-l-admin@midrange.com
10/10/2002 16:39
Please respond to rpg400-l


        To:     <rpg400-l@midrange.com>
        cc:
        Subject:        Re: Load all subfile


--
--
[ Picked text/plain from multipart/alternative ]

Mike, I've become a firm advocate of load-all, with a scroll bar.  The
limit
for a screen seems to be somewhere around 2000 to 2200 because above that
point a user cannot easily scroll to the item they want.  Even the
smallest
scroll bar movement becomes 100 or so records.

About performance:  This issue comes up regularly.  Lots of files in use
by
a user during the day are work files and auxiliary files that are usually
under 600 records.  My experience is that load-all is very fast and has
the
beauty of being a one-time deal.  After that, response time is zero.  If
the
subfile  could be 13,000 records, and the user used this file all day
long,
waiting 1 or 2 minutes extra in the morning for it to load would be a
small
penalty to pay to gain instant response dozens and dozens of times all day
long.

To make this load-all technique work best though you'll want to add in a
scroll bar.  They are nifty, they are attractive, and they work.  Your
users
need to be able to set a line at the top? So you need to write a dozen
lines
of code and test, etc?  Just write *SCRBAR in front of your *MORE keyword
and be done with it.

I sure do wish someone at IBM could add some white light to this
discussion.
 It comes up regularly and none of us really know the performance
constraints.

---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------

-------Original Message-------

From: rpg400-l@midrange.com
Date: Thursday, October 10, 2002 05:56:58 AM
To: rpg400-l@midrange.com
Subject: Re: Load all subfile

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Well first of all, I feel sorry for your users having to wait whilst 13000
records are loaded to a subfile! This should be reprogrammed to a page at
a time subfile, the IBM guideline on when it was worthwhile to build the
whole subfile at once used to be if I remember correctly for less than 50
records, let alone 13000.

Without having two subfiles, one for the first 9999 records, and one for
the next x thousand, and conditioning which one is displayed with say an F
key, nothing immediately comes to mind if you persist with the load all
technique.
--
[ Content of type image/gif deleted ]
--

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.