Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sort grid elements without index?
Message
From
28/05/2005 22:01:37
 
 
To
28/05/2005 12:50:04
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01018360
Message ID:
01018413
Views:
10
>>>
Create cursor .....
>>>Index on ... tag ...
will create an index in memory!
>>
>>Will it really? I am not sure about this, but I thought that perhaps VFP might decide from case to case (depending on size?) whether it is more appropriate to keep it in memory or on disk, just as it is supposed to do with the cursors themselves - or perhaps always put it on disk, with a temporary filename.
>
>Yes, as long as you have enough RAM, just like a cursor will also stay in RAM until VFP run out of resources, then it will swap to your HD behind the scene, and more or less out of your control.

Just a small point... I don't think it wil "swap" (i.e. go to the OS SWAP file) but rather to the HD, usually to the TMP directory.
Previous
Reply
Map
View

Click here to load this message in the networking platform