Searching .. Re: [thesite] meta description

Dean Mah dmah at shaw.ca
Mon Jan 21 10:10:22 CST 2002


To make this happen:

1) We need to install interMedia Text and index the content.

2) We also need to trigger a re-index when new data is added or
   updated and/or schedule periodic re-indexing of the table.

3) We need to change or add a CONTAINS clause to the search queries.

At this point, I'm not sure what the performance will be like in
either the indexing or the querying phase.  Also, I'm not sure of the
physical disk capacity required.

Dean


.jeff writes:

> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > From: Michele Foster
> >
> > Brings up a point .. are we going to work towards
> > searching the clobs now that Dean's done the main
> > content table as a test on t.e.o.
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> i see no reason not to.  it solves problems now without causing problems
> later.
> 
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > What needs to be done to now search this field? Indexing
> > via IntermediaText (or whatever it was called, Dean?)?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> not sure, dean?
> 
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > How many queries need to change?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> ostensibly only the article search and comment search queries.  the more i
> think about it though the more i'd like to just integrate the two into a
> single search, but that's a different discussion altogether.
> 
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > To what extent?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> supposedly just by referencing those columns with a CONTAINS clause.  dean?
> 
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > Does the amount of effort required outweigh the
> > benefits?
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> well, it'd make our searches 1000% more accurate so i think it's worth it.
> 
> here's a question though, what's the performance like?  dean?




More information about the thesite mailing list