General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I would imagine this:
>
>SELECT * FROM mytable INTO CURSOR mycursor
>
>would be faster than:
>
>create cursor mycursor (field definitions)
>select mytable
>scan
>scatter memvar memo
>insert into myCursor from memvar
>endscan
That's an unfair comparison, as SELECT * FROM mytable without
any WHERE clause will surely cause a FILTER cursor,
which would compare to USE mytable. That again is
xbase code and faster than the sql select.
Bye, Olaf.
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