Index Background Processing (OpenInsight 32-bit Specific)
At 13 MAY 2010 07:02:56PM Terry Rainville wrote:
In AREV after a index delay of say 5 minutes the indexing would start on a workstation.
After that indexing was finished you could hook in a subroutine to accomplish a task(s).
I am looking for the same function in OI 9.1 - anyone know how this is done, I found the timer setting for indexes but no where to hook in a subroutine call.
At 14 MAY 2010 09:07AM Dave Harmacek wrote:
In OI, you use a window TIMER event to run a process on a schedule.
A post-index routine isn't needed.
Dave
At 14 MAY 2010 09:20AM Jared Bratu wrote:
There are several changes to the index update procedure in OI 9.x that may be beneficial to you.
The RTI_Indexer routine was added to to update the indexes on a periodic basis. The task executes on the server from the server's scheduled tasks lists. This works well for tables that have numerous and frequent changes to indexed fields. This is similar to a dedicated index workstation.
In OI 9.x the database manager now includes the settings Update Before Query and Update Before Btree Extract. These two settings will force SELECT/LIST/and btree.extract() routines to flush the indexes before completing the query. The only time a call to update_index() is required is when using the IXLookup() function. This can be used without the RTI_Indexer process and is useful for tables that don't have as many changes to indexed fields.
At 17 MAY 2010 07:05PM Dave Harmacek wrote:
In the Programmer's Reference see:
Set_IDXSvr function
Set_Bgnd_IX_Time function
When you start the indexing and have a visible engine you will see indexing process messages.
I still advise you to setup a TIMER event to handle what used to be handled in the Arev Dos Post-Indexing Code Command. This is much
more flexible since it isn't connected to indexing.
Dave