Re: Subfile loading time tips needed

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

I switched from page-at-a-time subfiles to load-all subfiles a couple of 
years ago.  Subfiles per se are not particularly "labor intensive" (aka 
slow).  It is the disk accesses that are required to retrieve the data - 
whether native RPG I/O or SQL. 


Depending upon your file structure and the hoops you may have to jump 
through to get the "finished product," the latent time between request 
and display may be understandable (if not acceptable).  What I found 
puzzling, though, was that pressing F12 (which I'm guessing was to end 
the current list and start a new request) also exhibited the same 
latency.  Unless, of course, F12 is doing some additional processing, 
such as updating/adding records to a database. 


If you are having to read the entire (or a large chuck of the) table(s), 
this might explain the load delay, and reading between the lines of your 
problem statement, I got that impression.  I just ran a Load-All subfile 
over a master file (no extraneous processing - just a lit) of > 5000 
records using RPG I/O with sub-second response.  But it's a simple 
(item#) keyed table. 


My point is that there probably isn't much that can be done vis-a-vis 
the subfile (DDS) itself.  The subfile either works (displays what you 
want), or doesn't.  The response-time problem is probably in the file 
access, and not much information was provided in that regard. 



        * Jerry C. Adams
*iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.893.8633x152
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



steema@xxxxxxxxxxxxx wrote:

> THank you Mohammed, but can this be incorporated into the RPG?
>
>  
>
> > I am not sure what you are looking for but I think this SQL can you help u
> >
> > "select distinct fieldnames from yourlib/file where ?=?"
> >
> > steema@xxxxxxxxxxxxx wrote:  IOW, I would like to use the SQL unique
> > attribute for this file, as this
> > would cut down on the # of recs to read.
> > Can this be done w/ in the RPG ?
> >    
> >
> > > > HI I have a subfile that I am building in full, bec. there are some
> > > > related factors between records. If there is for example, a BOL number,
> > > > this same BOL could appear later on, and it is desired to have it
> > > > grouped
> > > > together, in the subfile. But this way, takes some time. There is a
> > > > definete pause of a few seconds, for each load, for each F12, etc...
> > > >
> > > > Perhaps I am lacking some understanding of subfiles so as to speed this
> > > > up?
> > > >
> > > > Steve
> > > >