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
 Site Related Forums
 Site Related Discussions
 Related Articles

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-12-21 : 13:53:42
Sam writes "At the bottom of each article you have a "related articles" section. I was wondering how you generate this list. Do you create it when a new article is added or every time the article is viewed? I'm looking for an effecient way of performing the same task in my application based on article keywords.

Thanks in advance for any help."

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-12-21 : 13:55:23
I generate it at the time the article is displayed. Each article/link in the database is assigned to a topic. I randomly select 5 articles in the same category or by the same author.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -