How to Stop indexing in OI and leave it to the AREV app? (OpenInsight Specific)
At 04 DEC 2001 09:18:53PM Scott, LMS wrote:
Hi all
How do I stop OI from indexing an AREV table that is indexed by AREV workstations?
Scenario: OI 3.3 (not my usual OI). AREV 3.12
OI app attaches the AREV tables to do pretty reporting and some data exports.
Unfortunately the OI app indexes some of the AREV tables and locks everyone else out. We'd be quite happy if the OI didn't index anything as all the AREV workstations are set up to index in a more sharing manner.
So I had a look in the forum for "STOP" AND "INDEXING" and got
ie Aaron said:
From the database manager, environment settings, then click on the indexing button
Which I did (ie OpenInsight | tools | Database manager ; Database | Environment Settings | Indexing button) and I see that I can turn off "index update before query", but is this enough?
Ie what about the "seconds before update"? Does setting that to zero stop it or make it immediate?
There was no "turn indexing off completely and leave it to the arev app" button on this form. Is there somewhere else I should look?
Scott, LMS
At 05 DEC 2001 02:04AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Scott,
what about the "seconds before update"? Does setting that to zero stop it or make it immediate?
Setting it to zero should stop background indexing which means you'd have to explicitly call update_index() in one of your OI programs to run any indexing code.
World leaders in all things RevSoft
