>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?
>

It depends on whether the query is Rushmore-optimizable; at a minimum, portions of the index files will get pulled to the local machine for processing if they aren't already in memory locally. If your parameterized view isn't optimizable, then large portions of the data file will have to come across the wire, too.

>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!