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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 To FTS or not to FTS

Author  Topic 

jbezanson
Starting Member

35 Posts

Posted - 2006-09-05 : 14:31:29
I am doing some research on Full Text Search (FTS) but haven't been able to find an answer to this question.

I am developing a Site Search Component for a fully dynamic CMS. What would the performace differences be if I used Full Text Indexing or just did direct search queries on the actual tables?

Thanks

Justin Bezanson

jbezanson@spatterdesign.ca
www.aspnetguy.com

jbezanson
Starting Member

35 Posts

Posted - 2006-09-06 : 10:44:56
Nevermind I am just going to use FTS anyway. CONTAINS and FREETEXT make it easy to search.

Justin Bezanson
www.aspnetguy.com
Go to Top of Page
   

- Advertisement -