Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK vs SELECT and _TALLY
Message
From
19/09/2000 02:24:49
Walter Meester
HoogkarspelNetherlands
 
 
To
18/09/2000 14:57:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00417361
Message ID:
00417961
Views:
35
Craig,

>>>Memory structures are different for arrays than cursors. I agree, that with a large array, paging could occur. But I think it is more likely to occur with a cursor because of the way they are managed.
>>
>>AFAIK, cursors (IF NOT FILTERED) are always stored on disk,
>
>Nope. if not filtered, cursors could be totally stored in memory.

So why does the DBF("myCursor") function always refer to a file on disk ???
Of course when a cursor is small, the cursor also exists in OS buffers (Thus memory), but when paging occurs (because of the length), it will be dropped from the OS buffer (or only for a part) but still will be hold the Temp file.


Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform