Home » Server Options » Text & interMedia » Dynamic text indexing
Dynamic text indexing [message #75975] Tue, 06 August 2002 05:07 Go to next message
Richard
Messages: 44
Registered: May 2000
Member
Investigating methods to dynmaically build text indexes with Oracle 8.1.7

I am running on an NT platform, and have Intermedia 8.1.7 installed. The Catalog search seems restrictive for what I want to do, however I haven't found any clean way to do dynamic text indexing (e.g. on insert into row, index text)

My text is stored in a row, about 200 characters per entry. Currently run Context bi-weekly, but now that the system is growing in usage, there is a demand to dynamically index the text (without spending money of course).

Any tips, hints or advice? I am new at this and would appreciate getting pointed in the right direction.

Thanks,
Richard.
Re: Dynamic text indexing [message #75986 is a reply to message #75975] Wed, 18 September 2002 04:40 Go to previous message
Laurent
Messages: 8
Registered: April 2002
Junior Member
Hi Richard

As far I know, InterMedia Text has (at least on Unix) a server named "CTXSRV" that can be started to automaticaly index the added/updated records in real time. Maybe you should investigate this way.
(cf http://otn.oracle.co.kr/docs/Oracle816/inter.816/a77063/cexec2.htm
and
http://hannibal.codet.net/docs/oracle805/DOC/context206/A54628_01/ch09.htm#365)

Note:
You can also update an intermedia index (without re-compute it entirely) by the command:

ALTER INDEX my_index_name REBUILD PARAMETERS('SYNC');

This synchronize the index according to the new/deleted/updated records since the last rebuild, (and it's much more faster then "ALTER INDEX my_index_name REBUILD;" that rebuild the rebuilds the entire index).

I hope this may (still) help you.
Previous Topic: Re: error while creating context index
Next Topic: Re: rename column
Goto Forum:
  


Current Time: Thu Mar 28 03:37:22 CDT 2024