>>>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.
Yeah we have been moving more and more temp stuff to the local machine and performance has increased tremendously. And like you said cleanup is very easy. We do the clean up when the computer is turned on.
Einar
Semper ubi sub ubi.