Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-06-23 : 05:01:44
|
| Hi, I need to develop a search application in which each word can be searched as it works in dictionaries. I was thinking of creating a table containing keywords and create an index on them. Since the search is done on some text files I think if it's better to save the files in a table then create another table which holds a reference to the keywords the file has!!Actually I'm not sure of the best design so any idea is appreciated.Please lead me to a proper forum topic, if here's not a good place.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-23 : 22:23:24
|
| If you save files in table, you can create full text index for that text column. |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-06-23 : 23:56:23
|
| Thanks for the responseDoes it have any impact on performance when having a huge amount of files? Besides, as I know from full text indexing it suggests same words (synonyms and derivable) in English as well, is that correct? |
|
|
|
|
|
|
Full Text Search!!