Re: Witango-Talk: Search Indexing

[Lance]

you could make use of fulltext indexing on the column containing the 
transcripts. checkout CONTAINS.

John Shaw wrote:

Hello again all,

I have about 2000 single page transcripts.  My org wants user to be able to
search the bodies of these transcripts.  I'm using SQL2000 for the db, but
I'm guessing these searches will take a lot of time.  So, I was thinking I
should use some sort of indexing process.  Like creating a table of words
used for searches and ID's of transcripts that contain the word.  That way,
I could check that table before doing the big search.
Does anyone have ideas or advice?

Thanks,

John Shaw

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
               with unsubscribe witango-talk in the message body
 



________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
               with unsubscribe witango-talk in the message body