What indexes do you have on the table? What level of optimization SYS(3054,11) returns for your query?
>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 ?
--sb--