Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which is faster?
Message
From
13/05/2004 19:16:40
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
13/05/2004 18:40:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00903686
Message ID:
00903907
Views:
14
I was mistaken. Thanks!

>
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform