[[https://www.revelation.com/|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]]


==== Btree Indexing (OpenInsight Specific) ====
=== At 20 FEB 1998 06:58:10AM Peter Bowyer, Swiftscan Systems wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
Has anybody had any problems with more than one user issuing an

UPDATE_INDEX command at the same time. we have a customer where the

indexes are not being kept up to date.

Any help would be appreciated. We are using OI 3.4.
</QUOTE>
----

=== At 20 FEB 1998 08:42AM Aaron Kaplan wrote:  ===

<QUOTE>Is this a question or validation of a hypothesis?  Do you think the running of UPDATE_INDEX is causing indexes to get set out of synch?



How is your indexing set up?  Do you have a dedicated indexer or does each workstation handle updates?  When you call UPDATE_INDEX is it for a specific file or for all files?  Is the 'update index before filter' flag enabled? (Yes, this flag is in OI and enabled by default.  From the Database Manager, Database-]Environment Settings.  Click the index button.)





apk@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>

----

=== At 20 FEB 1998 09:27AM Peter Bowyer, Swiftscan Systems wrote:  ===

<QUOTE>We are using UPDATE_INDEX('','',0) from an R/Basic program. Records,

particularly when deleted from a file do not appear to be updated in the index. For example, when running a program which either uses RLIST

or Btree.Extract the deleted record key is returned and therefore a subsequent read fails. Background indexing is on, update before query

is set and we are not using dedicated index server.

</QUOTE>

----

=== At 20 FEB 1998 09:50AM Aaron Kaplan wrote:  ===

<QUOTE>Even though I don't see why it should make a difference, try changing the UPDATE_INDEX calls to INDEX.FLUSH( '', '')





apk@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=9F46BCA65C59FADB852565B10041C045|View this thread on the  forum...]]