Hi David
Thanks for replying. None of my indexes include deleted().
When you say backend database, are you saying that using remote views will not increase performance??? Is it really necessary to go to something like SQL Server???
Also, while I was trying to get a remote view working I discovered that the remote view was not buffered. What is the best way to buffer a remote view???
Geoff
>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???
May all your weeds be wildflowers