Btree Indexing (OpenInsight Specific)
At 20 FEB 1998 06:58:10AM Peter Bowyer, Swiftscan Systems wrote:
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.
At 20 FEB 1998 08:42AM Aaron Kaplan wrote:
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
At 20 FEB 1998 09:27AM Peter Bowyer, Swiftscan Systems wrote:
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.
At 20 FEB 1998 09:50AM Aaron Kaplan wrote:
Even though I don't see why it should make a difference, try changing the UPDATE_INDEX calls to INDEX.FLUSH(
,)apk@sprezzatura.com