Re: Intermedia Catalog Indexing

"Richard" <richard_at_stoparczyk.com> wrote in message news:wSj39.340$M_6.175755_at_news20.bellglobal.com...
> I just got hit with the requirement to have dynamic indexing on text
 strings
> (for real time post and look up) and was wondering if anyone has
 experience
> with InterMedia 81.7 and the Catalog indexing.
>
> My scenario is a text column, reverse sort on date on results, and the
 text
> column typically has 200 characters in it.
>
> The part that scares me is that at the end of the year I will have a two
> month period where my user community of 35k+ will be pounding the system
 as
> they get there year ends in via the web.
>
> I have used Context indexing previously but I cannot be altering the index
> every transaction.
>
> Does anyone have experience they can share, horror stories, or
 alternatives?
>
> Thanks,
>
> Richard.
>
>

Platform? Nature of the data? DDL?

You are asking 3 questions - 1. real time indexing

                                             2. 8.1.7 experience
                                             3. catalog indexing

There are several ways to real time index - I believe the most 'real' would be to create a service that runs ctxsrv. Another would be to sync the index using DBMS_JOB to act as a scheduler. Catalog index has certain restrictions which did fit my particular installation.What may prove to be the most problematic is the sort requirement - which you will have to test.

HTH,
Tim Received on Mon Aug 05 2002 - 20:13:49 CEST