RE: Sub files in RPGLE

On Monday, October 19, 1998 7:29 PM, boothm@ibm.net [SMTP:boothm@ibm.net] 
wrote:
> This points out a question I have pondered.  Recently I loaded a subfile
> where I knew the records would be in excess of 3,000 but I was thinking
> I would load it and let it sit there all day, so loading wasn't a real
> issue.  (I was messing about with the green screen scroll bar and was
> curious about performance.)
>
> Imagine my surprise when the subfile loaded in under 3 seconds.  With
> that sort of performance page at a time can be reserved for truly large
> files, right?  But I have wondered if this was typical performance?
>  What are others seeing?

As always, it depends.
When the machine is busy, it takes longer to load.  Also, it matters how 
much total I/O is going on.

This is pretty fast even with 3000 records:
     dow
     read  txt
     write sflrec
     enddo

This can be pretty slow with 3000 records:
     dow
     read  invoicedetail
prod chain prodmaster
prod chain prodcost
cust chain custmaster
cust chain creditmaster
cust chain armaster
inv  chain invoicemaster
     write sflrec
     enddo

Buck Calabro
Commsoft, Albany, NY
mailto:mcalabro@commsoft.net

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