>>>When requerying view does foxpro bring in all records from server and then set filter to satisfy "where" clause condition or does foxpro bring in only records that satisfy "where" clause?
>>>Marat.
>>
>>Is it local view or remote? In a case of remote view you get exact recordset; in a case of local view you get quasi-exact recordset (if Rushmore available) or really move all records (if no Rushmore used).
>
>We have local views and we are running our application on network. On LAN it is OK, but one of our clients has a WAN which makes our application unexceptably slow, even though they have high speed connection.
>Marat

Naturally enough, WAN will be slower than LAN. The question is: how much slower. The only things you can do from software standpoint is to make sure that query is 100% Rushmore optimized and there is no any way to reduce number of records (by changing user's requerements) or number of joints (by changing interface approach).