Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
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
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