Temporary index files

skalyanaraman · Post by **skalyanaraman** » Thu Jun 07, 2001 3:25 pm

Hi,
We are using Texis version 3 (march 15 2001) on windows NT. We just moved to this new version. We are seeing a unique issue here. After we create the table, load data and index them, certain metamorph indexes are automatically getting updated. So, the T00* files are being created for these indexes. Looks like there is a pattern. The indexes on fields which are BLOB's are getting updated automatically.
Any reason?
Will this create any problems? Some times when these T00* files are created and we drop the index the files are still hanging around until we manually delete them.

Any help is greatly appreciated. Thanks!!

Post by **Kai** » Thu Jun 07, 2001 3:45 pm

The database monitor will automatically update Metamorph indexes occasionally. If you update your tables in batches, then it's probably better to manually update the indexes yourself after your table updates (by re-issuing the original "create metamorph index ..." statement).

You can turn off automatic index update by setting Automatic=0 in the [Chkind] section of your /usr/local/morph3/texis.cnf file:

[Chkind]
Automatic=0

(Create the file with an ASCII text editor if it does not exist already.)

Post by **John** » Thu Jun 07, 2001 3:46 pm

By default the index will get updated if there is more than 1Meg of new data. It should not cause any problem. If searches were going on while the index was dropped NT is unable to remove the files. The index should still exist in SYSINDEX, but marked as TYPE "D" for deleted, and then they will be removed once they are no longer locked.