General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Is traditional do while...enddo faster than sql select ?
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 ?
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