Still having indexing woes (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 05 NOV 1997 09:29:08AM Gary M Breeding wrote:

AREV Specific

HI again,
I'm still having trouble with file indexes being 
corrupted. Based on the messages I've mentioned in

other Topics, I have noticed that at some point

I can expect that certain links in the Btree index

do not get written back to disk, and then the next

time a user hits a pointer to the missing link, an

error message occours.

My attention has come to the fact that the hardware

comfiguration may have something to do with this

problem. Recently, certain Pentium workstations

have been introduced into the network (Novell 3.12).

One area that used to have a 486x33 is primarily

responsible for the generation of rows into those

files where the index link error are occouring.

My thinking is that one should not have a work

station that is faster than the server (a 486x66).

Is it possible that this Pentium workstation could

be causing the problem?

This AREV system (v3.0) has been up and running

without even a GFE since Jan 1994.
It has been suggested that the NLM is the cure
for this problem. Could you explaine how this is

so? The published 'Facts and Features' sheet

only mentions the reduction of GRE's when using

the NLM. What about the index links? We have not

experianced any GFE problem, just missing links,

and on one occasion, we found that an entire

indexed column was reported to be missing.

Please HELP…

Thanks again,

Gary M. Breeding

At 06 NOV 1997 09:28AM Jason Snow, Tech Support wrote:

Gary,

Are the new workstations Win95? If so, you will encounter problems because of the way that OS caches and flushes transactions. In any case, using the NLM will eliminate win95 related problems, GFE's, and in most cases give a performance boost too.

Jason

At 06 NOV 1997 10:23AM Tracy Graves wrote:

Gary-

I'm not sure what effect having a slower server than

workstation would have. That could be the why of what

is happening. Are the new workstations configured

exactly the smae as the older machines (caching, file

sharing, etc?)

As far as what the NLM would do, missing/misdirected links or

columns looks to me like the definiton of data

corruption, or a GFE, which is what the NLM would

be preventing.

Tracy

At 15 JAN 1999 09:50AM Matt Fields wrote:

Jason wrote:

"In any case, using the NLM will eliminate …
                  GFE's"
No, there's a BTRIEVE issue,

see

http://www.revelation.com/WEBSITE/knowledge.nsf/ada4f7f66610cc27852566f500656a3f/4c5a1bff88b1cd61852564a40079a0d0?OpenDocument

View this thread on the forum...