>Because you are, in reality, only setting a filter in the table and the browsing it across the VPN.
>
>Try adding 'NOFILT' after the SQL statement and see if that isn't faster, assuming that you have the correct indexes, etc on the orignal table

That could be it! I missed the vpn part.

>
>>hi all !
>>i test my application with share data folder in remote server with vpn
>>i found that the tradition way is much much faster than the sql statement
>>
>>use \\server\data\mytable order ac
>>seek m.ac
>>do while ac=m.ac
>> *** get some data and append records into tempcursor....
>>enddo
>>sele tempcursor
>>brow
>>
>>i try sql statement
>>sele * from \\server\data\mytable where ac=m.ac into cursor tempcursor
>>i've found that it takes very long time to show the tempcursor
>>
>>why ?