Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can an index be temporary?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00747109
Message ID:
00747433
Views:
20
>>>To avoid problems with multi-user access, a temporary index should not have a fixed name. Assign sys(2015) to a variable, create the index with that name, and delete it later.
>>>
>>>Hilmar.
>>
>>Yes we use a tempname function with the random generator function to ensure unique(well close to unique) idx name.
>>
>>Einar
>
>Another thing is that such temporary indexes may be created on the user's local drive instead of application directory on the network. That simplifies the uniqueness problem - SYS(2015) is enough - and kind of speeds up the indexing. Also, the application on quitting may just wipe out all temporary indexes on local temp directory at once.

Nick, the .IDX file is temporary only in that you don't need it any more. You still have to clean it up yourself. The only temporary index file would be a .CDX created on a cursor, that would delete itself when you close the cursor.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform