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)
 Text Search

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-24 : 10:12:11
Kelvin writes "I am trying to build a website that allows user to post articles (each has about 2500 characters) by inserting the articles into the sql server. I am expecting to have about 100K+ records within a year. My question is how can I search the database(the field that stores the articles) to find out if an article has the word(s) that I am looking for? Would it take lots of time and consume lots of server's resources? Can you suggest an efficient way to do the search?
Thank you very much."
   

- Advertisement -