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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-14 : 08:58:56
|
| DaGees writes "Dear SQL Team,I am building a weblog / forum (kinda) website with ASP.NET for Windows 2003 Server. I use a SQL server 2000 database for my website.One of the things that I really find important when building a website, is performance.Now, I want the visitors to be able to search through articles, which are fields of type 'text'. I know that I don't need Full Text Indexing to do that. So when users enter their search string, I usually split that string on spaces, and then I build my query so that it becomes something like this:SELECT * FROM TABLE WHERE UPPER(COLUMN) LIKE '%VALUE%' AND UPPER (COLUMN) LIKE '%OTHER VALUE%'Searching that way and ordering the results by datetime always worked fine for me.But the results aren't ordered by revelance, ofcourse. That's where full text indexing comes into play. Or is there another methode like "Order by revelance" ?So I have basically 2 questions:- Is my classic method a faster method for doing searches? - And if so, what will the performance impact be when using full text indexing?Thank you in advance." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Full Text Indexing and performace? 