Re: Intermedia Catalog Indexing

Your right, I was a bit brief. Running under an NT 4 platform IIS serving an ASP front end to Oracle 8.1.7 on a seperate server. The nature of the data is text in a row. Averages about 200 characters. Never more than 300, and often less than 100. However it may be in one of two languages, english or french.

My sorts are by one date field (and relevance using scoring) however there are a number of small fields (booleans, integers and dates) that the user may use to filter the results. Most choose not to. Again, I am new at integrating text indexing in Oracle.

You mentioned in your reply using ctxsrv as a service and doing real time indexing. I am new to text and Oracle and didn't believe that this was possible. Would this be using the context index functions? I had assumed from the docs (and the set up that I inherited) that indexing had to be performed at a set point in time.

My restriction right now is to not spend $$$ (like I haven't heard that before) so I assumed I was limited to what Intermedia 8.1.7 offered, which seemed to be Context Indexs which could not be built dynamically and Catalog Indexes, which could be built dynamically.

Off to reread documentation. And thanks for the help.

Richard.

<timkarnold_at_comcast.net> wrote in message news:xfz39.50211$yc3.1642146_at_bin4.nnrp.aus1.giganews.com...
>
> "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 Tue Aug 06 2002 - 05:27:53 CEST