GO BOTTOM will not be reliable and as the size of the file grows, the performance will drop.


Normally this affirmation is false.

This is true only if a filter ( like SET DELETED() ) hides a number much elevating of records to the end of the table.

With a index active it is a seek to the last index key. o(Log(N))

without index it is a simple file seek ( like GO RECCOUNT()):
FSEEK(tableHandle,HeaderSize+1+(RECCOUNT-1)*RECSIZE) o(1)

After, VFP start a backseek/backscan to found the first record visible.

Fabio