INDEXING SERVER PROCESS (OpenInsight 32-Bit)
At 27 AUG 2010 10:03:33AM Martin Drenovac wrote:
Could I possibly get a pointer where to find info on installing an indexing service on the server.
I want to install 2 indexing services, one for 1 table, and the other for every other table that we index.
Am I correct that it is more effective to index on the server that to have user workstations carry out the indexing process - one of the main operations in our application always force flushes the indices on a file to ensure that the change just written away by itself is available immediately for selection. However, 65 workstations indexing randomly is causing grief and network traffic that we'd like to avoid.
Thank you
At 28 AUG 2010 12:12AM David Goddard wrote:
G'day Martin,
Open the OpenInsight Help and search for RTI_INDEXER. This will tell you all you need to know to get your background indexing service(s) setup.
regard
Dave G
At 07 SEP 2010 04:45AM Mark Marsh wrote:
from the command line use the /i switch to turn an Engine into an Index Oengine.
or in code:
set_bgnd_ix_time(4)
set_idxsvr(1)
handle=findWindow( 'Arev':\00\, '')
stat=showWindow( handle, 1)
Running the indexer on the server ? In theory is ok if your not splitting your data across volumes. (Ive seen issues in that scenario) But then youd be running potentially your heaviest processes on the server everyone is reliant on ?? your better off dedicating one or two pc's to the task.
You also need a way to dynamically attach / detach the data for your indexer if you want them to index different data pools. I achieved this by having a logon script which checked the @Username and then attached the relevent pool of data.
At 07 SEP 2010 11:23AM Bob Carten wrote:
Hi Mark
You can run the oengineserver as a service on machines other than the server. So you can deploy RTI indexer to ( or any other Engineserver process, including RTI_TASK_SCHEDULER, OERUN.EXE, OECGI2/3, NetOI ) on one or more "application servers" separate from the data server. There will be a lot of I/O between the application servers and the data servers, so you want them to be pretty close. Your comments about wanting or needing to attach custom lists of tables still apply when using the Oengine server to perform indexing.
- Bob