We are considering the best solution for a 125 plus user VFP app running on 100mps NT network. The client isn't ready for SQL Server at this time but will be soon. The question is this...what does VFP send over the network when you use a parameterized local view? As with any query, VFP opens the tables used by the local view. Does the whole table come across the wire?

We are wanting to write the app using local views running against a VFP 5.0 database on the server. Speed and reliablity are a must.

Any expertise or ideas would be greatly appreciated!