>>also, are you saying that using SQL Server would be faster on
>>a WAN? :)
>
>Yes. Because all of the query processing happens at the server, SQL Server only needs to send the results back over the wire. When you do a query with just VFP, VFP needs to pull at least part of the index over the wire to find the right records to return. It then has to bring those records over the wire. Generally, VFP performs best with a powerful workstation and a fast network. SQL Server's performance depends mostly on how powerful the server is (though both can be slow if your queries return a lot of data over a slow network).
---
thanks again Josh - I must use the VFP tables for my app. On the WAN, the lines are being changed from 56K to T1 lines. Do you think that will take care of my
problem with data retreival, since my apps runs great on a local area network?
:)