Hi!

I'm looking for a quicker way to perform searches in SQL Server.

I posted a question in Experts Exchange:

" We have a number of ASP/VBScript web sites where the content is stored in SQL Server. Often content consists of articles, with large text fields. We like to give visitors the chance to search through these articles through an input field. These searches are done with ADODB and take a very long time when there are many articles to search.

Is there a way to make the searches go faster?

Thanks!"

I received the following answer from wael:

"I thin kyou can adopt the following search technique to make the search faster:

* In the Insert Article and Update Article you can summarize the posted article into keywords and to be stored into another table (For instance "ArticlesKeywords (KeywordID, ArticleID, Keyword)") related to the Articles table and make the indexs on this new table

* then the search page will search the ArticlesKeywords table and return with the articles ID that contain these key words

The best implementation of this technique is DotNetNuke search module (www.dotnetnuke.com), its ASP.NET and MSSQL but you can refer to its DB design it will help."


I can't seem to locate this Search module. Any help would be appreciated.

Thanks!