>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).