RE: Sub-Files

[John Carr <74711.77@xxxxxxxxxxxxxx>]

Still don't agree.

How about  a page at a time subfile with the ability of the user to sort
the screen by 5 or
more different criteria?   Sort subfile by say;  Customer, Part, Invoice,
Date, Work order etc.

The user would then have the ability to get to exactly the record she/he
wants within one page.

That would be better than have her/him  scrolling through thousands of sfl
records just to get
to the one they want.   Much better for the user.   

If the user can't get to(position to)  the DB record they want within one
subfile page(having to scroll and scroll and scroll)   then I think I
didn't do my job.     Even if the scroll bar is cute and looks PC'ish. 
It's not as functional as keying in one piece of data and having the list
panel start there.

Remember the physical laws of I/O's.    xxxx amount of them equates to
Seconds of response time.
No getting around it.   Then consider the Shared Locks and seizes on the DB
records, etc..

The most expensive CPU time is I/O time,  Especially if the user is looking
for One DB record 
and you're loading and presenting her/him with thousands that they didn't
want in the first place.

Again,  Just my opinion.
Booth,   Did you see my RPG & Maintainability session at Boston?

John Carr
EdgeTech


-----------------------------------------------
Message text written by INTERNET:RPG400-L@midrange.com
>
I mucked around a bit with this issue and my conclusions were that at about
a 3,000 record size file the whole thing began to sag of it's own weight. 
A scroll bar was effective for up to about 1500 records, and no longer
useful at 2,500 records. In the end!
 I decided that my own little book of rules would include a complete load
of the subfile with a scroll bar for files unlikely to grow beyond 2,000
records.  Above 2,000 I just make a page at a time subfile program with
(pagesize times 2) for the READP dimen!
sion.

That is of course my opinion only, on one machine only.



In <199904110009_MC2-713F-9F75@compuserve.com>, on 04/11/99 
   at 12:06 AM, John Carr <74711.77@compuserve.com> said:

>From: joycej@us.ibm.com

>>Is there a maximum number of records one can read into a sub-file?  Say
>10,000?
>>I'm experiencing a problem where my record count is 10,575 but I do not
>see the
>>corresponding data when I go to the end.
>>
>>Thank You
>>Joyce

>Joyce;
>First,   tell me,   do the lights dim while you're running the program?  

>I'd say that over 50 I/Os per enter key puts you in the masochist arena. 
>Why oh why would you ever want to put that many records in a subfile?
>Will the user EVER read even a small fraction of them?   

>What ever the business need is,  There HAS to be a better, easier way.

>Ok,  let the flames start.

>Respectfully 
>John Carr
>EdgeTech
<

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *