performance loading a subfile

[booth@xxxxxxxxxxxx]

Here's the scenario:

A large file is being loaded a page at a time, 10 records per page.  There 
is a filter set for one of the fields.

With no filter set the subfile loads quickly and happily.  However if the 
user chooses to filter out  99.5% of the records then loading the 10 
records may take thousands of reads to find 10 that pass.  In this case 
the performance is dreadful.  The selection is worth it so we wish to do 
it but is there some way to display records as we go, or choose a line 
before the whole subfile page is full? 

(I know how to set a progress bar but that isn't really the answer in this 
scenario.)

_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---