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 |
|
sggy
Starting Member
8 Posts |
 Posted - 2007-06-05 : 12:22:35
|
| Hi everyone, I am starting a new exciting project - db content search.Do you have any ideas how to implement db text search besides using SQL Full-Text Search? One of the ideas is to break the sentence into keywords and tag/rank them. It is a part of Full-Text Search functionality. But we are trying to find a workaround and not use Full-Text Search because of the multiple indexes that are created on the text column.Thank you for your help in advance |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-06-05 : 13:26:16
|
| Are you thinking you are going to create your own solution that is faster and more functional than the solution provided by Microsoft?And your solution will give good performance without using indexes?You must have some talented developers.e4 d5 xd5 Nf6 |
 |
|
|
sggy
Starting Member
8 Posts |
Posted - 2007-06-05 : 13:37:12
|
| thanks for you reply. You made me laugh. You are actually right. Our goal is tooo ambitious. :):)i will take a look at the cons and pros of the MS search engine and reevaluate it for myself:) |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-06-05 : 15:33:07
|
| If you need functionality that is not included in full-text indexing, then roll your own. Otherwise, its rarely a good idea to reinvent the wheel. Particular wheels manufactured by, say, BMW.e4 d5 xd5 Nf6 |
|
|
|
|
|
|
Database Search