Index errors and Miscellaneous questions

[skalyanaraman]

Hi,
We were running a script file on UNIX to create indexes on a particular Texis database. Most of the indexes finished, but some of them failed with the following error,

002 Metamorph index file /database/tbldiscovery/idxmtbldiscovery_SAVED
NATIVEDOC.btr already exists in the function openwtix

Why is this happening? One more info that maybe of help is, that there were sporadic record deletes on that database.

Miscellaneous,

We ran a OR search using the OR clause and also using @0. The indexes are all up to data. But, the search with OR clause took 10 times longer period than the same search with @0. Why??

Thanks!!

[mark]

Is the file mentioned always the same regardless of the index name? What is the create index statement for the corresponding error message(s).

http://thunderstone.master.com/texis/ma ... 3d5d59e811

[skalyanaraman]

No, It is the index name on the field we are indexing. Here is the create index statement for the corresponding error message.

tsql "set keepnoise='on';set delexp=0;set addexp='\alnum{1,99}';set addexp='>>\alpha{1,50},=\alpha{1,50}';create metamorph inverted index idxmtbldiscovery_SAVEDNATIVEDOC on tbldiscovery(SAVEDNATIVEDOC);"


Also, if OR search has to compare each record on the database why @0 takes shorter time? just professional curiosity.

Thanks!!

[mark]

You're not on a filesystem that truncates (or otherwise mangles) filenames are you? Try using a shorter name for the index.

Texis is optimized for text, so Metamorph (like, likep) is faster than SQL, though we're working in improving SQL too....