Re: Intermedia Catalog Indexing

"Richard" <richard_at_stoparczyk.com> wrote in message news:udH39.6675$HH2.549011_at_news20.bellglobal.com...
> 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
> >
> >
> >
> >
>
>
same platform for me, but we are upgrading to 9.2

>Would this be using the context index functions?

yes and no. I believe it calls the same functions, but is less efficient. The upside is real time indexing. The downside is index fragmentation. There are scripts that will allow scheduling of index syncronization every 'x' seconds. I'm sure it available on the WEB somewhere. But I'll email them to you if want. CTXSRV is the less preferrred method (may be deprecated soon), but I can't answer exactly why. CTXSRV can also be invoked from the GUI -- a TCL script.

re: sorting I believe I've read some people having problems with an additional sort

[Quoted] eg 'select * from tabA where contains(fldX,'junk') > 0 order by fldB'

We have not had a problem with sorting and we are doing the same thing. About 600+ characters, 100,000 records. But we also restrict the result list to <500.
You will have to test,test,test. And if there is a problem look at the explain plan, try hints, etc.etc.

Regards,
Tim Received on Tue Aug 06 2002 - 14:16:29 CEST