Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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 ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only