|
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.
midrange.com
* 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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
