New version and chkindex

Post Reply
skalyanaraman
Posts: 109
Joined: Tue May 29, 2001 9:13 pm

New version and chkindex

Post by skalyanaraman »

Hi,
We installed the newest verion of Texis recently. Ever since we had the chkindex automatically.
Mark helped us out by asking us to update texis.cnf.
Related to this, we have a problem.

1. We were deleting/adding/updating records to a table.
2. the Check index started to run automatically.
3. we were also running a full reindex.
4. we probably did a monitor -k after the cnf change.
5. Now, eventhough the indexes are there, the searching on even a single record is VERY SLOW.

Is there something we can do tell texis that the indexes exist now like updating stats or something?

Is re-indexing the only option? It takes a long time as the data is around 40GB or so

TIA
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

New version and chkindex

Post by mark »

The question is what state the index is really in since a second update wouldn't start if one is already running. How big are the _T.btr and _D.btr files?
Post Reply