Re: best efficiency for full-text search

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lowell Heddings (lowell_at_mindjunction.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 02:52:56 -0500

In my experiences, you would definitely want to handle that outside of
the SQL code. It's easy enough to write some code to handle it.

I do something similar to this, which eliminates parsing:

keywords = replace(keywords,"AND NOT","~AN~")
keywords = replace(keywords,"AND","~A~")
keywords = replace(keywords," "," ")
keywords = replace(keywords," "," AND ")
keywords = replace(keywords,"~A~"," AND ")
keywords = replace(keywords,"~AN~"," AND NOT")

etc etc etc

I'm sure there are a lot of ways to handle it much better, but that's
how I've done it, and I use the same block of code in every app that I
write, so I don't have any need to find a better method.

Also, one of the problems with full-text searching that I've always
found is using multiple columns... I use a single column that I concat
all the other fields into.

Lowell

Random wrote:
> I have created and populated a catalog on my table to enable full-text
> searching, no problems. Now I want to implement a stored procedure to run
> the search based on a delimited string of keywords. I am wondering if there
> is a de facto accepted method for parsing the keywords, and running them
> against the catalog for a prioritized result set.
>
> I'm not a fan of using dynamic sql inside a stored procedure (kinda defeats
> the purpose), so I'm wondering what others here might recommend before I
> proceed really far into this.
>
>

Relevant Pages

  • best efficiency for full-text search
    ... I have created and populated a catalog on my table to enable full-text ... searching, no problems. ... the search based on a delimited string of keywords. ... I'm not a fan of using dynamic sql inside a stored procedure (kinda defeats ...
    (microsoft.public.sqlserver.programming)
  • nail omits Pervez AL-Assads return
    ... When searching for derogatory references to President Richard M. Nixon ... This is done by selecting keywords that match against the routing ... The phone analogy is recipient and originating phone numbers. ...
    (rec.ponds)
  • Both suming now, Pervez and Marwan focused the annual matrixs for instance passing scope.
    ... When searching for derogatory references to President Richard M. Nixon ... You may wonder what keywords excel at picking up "resume condition" traffic. ... The phone analogy is recipient and originating phone numbers. ...
    (sci.crypt)
  • Mahammed shuts the dividend out of hers and upstairs heads.
    ... When searching for derogatory references to President Richard M. Nixon ... You may wonder what keywords excel at picking up "resume condition" traffic. ...
    (sci.crypt)
  • Re: "Google Like" with weighted searches project
    ... entering of keywords, that a web user enters, and then searching MSWord documents for those words. ... assigning it an integer as to it's place in the document and some other information that would be useful in searching ...
    (microsoft.public.dotnet.general)