Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    India
    Posts
    31

    Cool Unanswered: 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!!
    Do not walk behind me, for I may not lead.
    Do not walk ahead of me, for I may not follow.
    Do not walk beside me, either.
    Just leave me alone.

    Yogesh Jangam
    http://yogeshjangam.blogspot.com

  2. #2
    Join Date
    Sep 2003
    Posts
    39
    Reasonable would be a full-index at night, when traffic is low on your website and incremental during the day.

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    31
    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
    Do not walk behind me, for I may not lead.
    Do not walk ahead of me, for I may not follow.
    Do not walk beside me, either.
    Just leave me alone.

    Yogesh Jangam
    http://yogeshjangam.blogspot.com

  4. #4
    Join Date
    Sep 2003
    Posts
    39
    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.

  5. #5
    Join Date
    Jan 2004
    Location
    India
    Posts
    31
    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]
    Do not walk behind me, for I may not lead.
    Do not walk ahead of me, for I may not follow.
    Do not walk beside me, either.
    Just leave me alone.

    Yogesh Jangam
    http://yogeshjangam.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •