Full Text Search

Hi

This is Yogesh Jangam
I m using SQL Server 7.0 and ASP for an intranet application
I am using Full Text Search feature os SQl 7.0.

The problem is i am not sure where to populate my Catalog which i am using for searching Articles. Basically, Various writers will be submiting, approving Articles which can then be searched by other users to be read or referenced

i was thinking to populate full or incremental, once an Article is approved, but i think it is time and resource consuming

any way

suggest me!!Reasonable would be a full-index at night, when traffic is low on your website and incremental during the day.|||Originally posted by beyond cool
Reasonable would be a full-index at night, when traffic is low on your website and incremental during the day.

hey thnks

I also wanted to ask abt Index Server

I want to search thru articles and files uploaded with it.

It will have a search window with search string and an "Include Files" checkbox.

Shud i implement FTS and Index Server Search separately or is there any way to integrate those

bye|||Originally posted by yoja7
hey thnks

I also wanted to ask abt Index Server

I want to search thru articles and files uploaded with it.

It will have a search window with search string and an "Include Files" checkbox.

Shud i implement FTS and Index Server Search separately or is there any way to integrate those

bye

I'm not sure. All the implementations I've seen however have had separate implementations that were somehow combined, eg, return the FTS results first and then append the ISS results.|||Yes

My colleagues also give me same suggestions like

do FTS first and Index later

or display one FTS result and one Index search result

lets see how it turns out.

I was also trying to do Incremental Scan for FTS when a Article is approved [but i am worried about performance of my application]