Hi,
In a LAN using DBFCDX If I Open a table of 68000 records
(123 mb dbf 2 mb fpt and 11 mb cdx files) if I skip +1 or -1
it's fast.
If I SKIP +1000 and SKIP -1000 it takes 2 seconds. If I SKIP 9000 or
SKIP -9000 it takes 20 seconds.
How does the SKIP command works?
DavidMany Thanks to all!
He wants to SKIP records folowing the order set by the active index and honoring filters, not moving the pointer in the physical order of the records.
Regards
Claudio H
dbgoto(recno()-1000) ... should be pretty fast.I have verifiedi this is very fast
it would be nice if you could do something like that
nCurKey := OrdKeyNo()
SkipKey( nCurKey + 1000)
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 379 |
Nodes: | 16 (2 / 14) |
Uptime: | 70:31:51 |
Calls: | 8,084 |
Calls today: | 2 |
Files: | 13,069 |
Messages: | 5,849,821 |