I am not sure whether you're keeping the VFP table around permanently? Sounds like you are, with the extra fields only available through your app stored there.

Assuming you are, then you want to just bring down the keys into this table plus anything needed for sort orders, not the whole thing. Even when you do this load, you may be able to smarten up the load so that it only brings down new records and checks for deletes.

Now, for your additional fields: Run your query against a single record. Refresh it when you change records.

I've had some wierd resource problems I had to trap for, and, FWIW, it's possible to really kill an AS400's performance for other users if you rapid-fire queries from VFP via SPT. So you need to coordinate this with some performance testing (resource-watching by your AS400 admin folks).

If you experience problems like this, mirror or cache a limited subset at a time (IOW, implement "paging" based on the current order in which you are displaying records).

>L<