Search from file vs. search from sql ntext field

Question

I'm creating news portal site. this saves to many news.Every news has html data. i'm using SQL Server 2005. I have 2 choices.

1. Save news data to ntext field.
2. Save news data to html file and save file name to nvarchar field.

What is best way to good performance and quick search operation. If i choose second way, when i search from news, i'm repeat every file and search from each.

What is best?

You have another way?

EDIT

Maybe my news count increasing over than 100,000. Now count is 1000. But SQL Server database size is 60Mb.

Answer 1

Use nvarchar(max), not ntext for storage. Use fulltext search for searching. Use the FILESTREAM storage if the content are documents that have to be accessed by Win32 API.

• Querying varbinary(max) and xml Columns (Full-Text Search)
• Best Practices for Integrated Full Text Search
• SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned
• Using FILESTREAM with Other SQL Server Features