I am using Arev 3.12 with NLM, Novell network 4.11. Win 98SE and one XP.

I have set up one workstation to be the dedicated indexer on our network after having all workstations share indexing for 4-5 years. I have noticed that before, when a machine was indexing, (INDEXING being shown in the status bar) there would be activity on the server. That is I could hear the server hard drive spinning.

I have now noticed on my indexing machine that when I first log on to Arev the indexing will start after the preset delay and I can hear the server running. Then I come back to the indexing machine 15-20 minutes later, and "INDEXING" is still on the lower right of the status bar, but no server activity. If I exit from Arev and get back in, I can get the server activity again, but I am not sure what file it is having trouble with.

I have not noticed any inconsistancies in my data but when I try to use a SELECT statement this sometimes prompts an index update. I would think that the indexer would have already updated the indexes.

Any ideas how to troubleshoot this?

Thanks

No disk activity could be the result of a cache.

Workstations updating indexes before the filter means that the update index before filter flag has been enabled.

The Sprezzatura Group

World Leaders in all Things RevSoft

You could write a programme to update each table's indexes in turn, displaying a message as it does. That would let you see if there is indeed a problem. I've got code I'd be happy to let you have for this. email me at jb@psi.net.nz

J

I have been working with our consultant on a program to do just that. Currentlt it attaches a volume and will flash up which file it is using. When it stops it shows which volume but not the file.

I will tinker with that first, but I appreciate your offer.

View this thread on the forum...