Geoff,

VFP is still going to have to pull significant parts of the CDX across the wire to know what records it should retrieve. If you have an index on deleted() and SET DELETED ON that might also be affecting performance because that index gets dragged down the wire. Network wire probably isn't even going to give you better than a few mbit/sec because you are sharing that network resource with everyone else.

If this sort of operation is too slow for you, you should consider switching to a backend database.

>This is across the LAN, strangely enough the system has a webserver attached which is stacks fast than the LAN even over 56K.
>
>Am I correct in assuming that remote views will significantly speed this up???