General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
What I ended up doing for now is:
*Create a cursor.
SELECT mytable
lnrecno = RECCOUNT() - 100
GO lnrecno
SCAN REST
SCATTER MEMVAR
* INSERT INTO mycursor FROM MEMVAR
ENDSCAN
This greatly improved the speed of getting the last X number of records. The table I am querying contains over a million records. Indexing on RECNO() is the real answer but I cannot take the time to do this now.
>I know there is something else that can be done, if I think of it I will post it
>
>
>>Thanks for the help, I was trying to avoid indexing on recno() but it sounds like I'll have to.
>>
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