|
Posted by Mike Willbanks on 05/16/05 05:00
Maziar,
> I'm designing an application and have field defined in a table as Text where
> I store Articles. I need to search the contents of my field for specific
> keyword phrases for all the rows (5000+ rows). What is the best method to
> do this? Should I use indexes or FullText? Also with indexes what would be
> the best Key size?
Fulltext would be the best otherwise what you can also do is make a
search table for it.
Basically it is a word list that associates the amount of times the word
is found, the word itself and the article it is associated with. As for
doing phrases fulltext is the best bet.
Mike
Navigation:
[Reply to this message]
|