Software/Hardware used:
you use a subfile to display multiple related records, such as line items on a purchase order. A subfile can only contain 9999 records, so if you have more than that you need to do page-at-a-time (PAAT) subfiling and control populating the screen with the correct next/prior set of data. In reality, no one would want to look through 9999 records, so you would want to do PAAT much sooner. Load-All subfiling is appropriate when they are a relatively few set of records, such as a prompt list of reason codes for why the user wanted to cancel a line item on their purchase order.
Regarding BigKat’s answer, if you allow “position to” on the SFL, PAAT is better because they you can allow Page Up, if the user has positioned past where he wanted to start,
Regarding the question, it is never necessary to use a load-all subfile. The major reason that a load-all subfile is used is simply because it is easier to program.
Any of the usual uses of subfiles can be done with any of the subfile types, including “Position to” and page-up/page-down although the subfile might need to be reloaded to make it look as if it’s happening naturally.
Tom
so, Page-at-a-time(PAAT) subfile will have a better performance when compared with other two i hope.ThanksSurey.
Page-at-a-time(PAAT) subfile will have a better performance…
Usually performance has essentially no relationship to subfiles. One type of subfile will probably be indistinguishable from the others in terms of performance.
Tom