RE: Subfile performance question

Not true.

One page loads are a pain for the user only if you allow it to be a
pain. There is no need to accept/process everything on one page before
moving to next.

Check out...

http://www.itjungle.com/mpo/mpo052302-story05.html



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: 17 February 2010 17:20
To: RPG programming on the IBM i / System i
Subject: Re: Subfile performance question

Depends on what he means by allowing the system do the scrolling. He may
be
referring to load the entire subfile of data and then letting the system
roll up and down. If true, depending on number of records it can be
significantly slower but just the load time.

If you are talking about loading a page at a time and then have the
system
roll back and forth from what has been loaded I would say the system is
faster. One page loads are pain for user. Each time they roll everything
is
wiped out so anything they want to do on that page must be done and
accepted
on that page and that is slower because you have to go through the
database
and load logic. OS is just rolling back and forth thru a user space or
memory.



On Wed, Feb 17, 2010 at 9:55 AM, <Rick.Chevalier@xxxxxxxxxxxxxxx> wrote:

A coworker stated the other day that handling the page-up and

page-down of

a subfile in the RPG program was more efficient than letting the

system

handle the scrolling. They couldn't give an specific reason just that
'that's what I have always been told'. It was news to me and I'm

having a

hard time seeing how that would be true.

Does anyone have an information or links to information about the

scrolling

efficiency of a subfile vs. scrolling in the RPG program? I may write

a

couple of test programs to do some timings but thought I would ask

first. I

don't write a lot of subfiles these days and writing them would not be

a

simple task as my subfile skills are rusty.


Rick Chevalier
IT Software Solutions - Loan Servicing
[http://www.americredit.com/images/acf_email_sig.gif]
817-525-7178 (w)
rick.chevalier@xxxxxxxxxxxxxxx<mailto:rick.chevalier@xxxxxxxxxxxxxxx>



________________________________
Privileged and Confidential. This e-mail, and any attachments there

to, is

intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this

e-mail in

error, please notify me immediately by a return e-mail and delete this
e-mail. You are hereby notified that any dissemination, distribution

or

copying of this e-mail and/or any attachments thereto, is strictly
prohibited.

--
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.