开发者

Search from file vs. search from sql ntext field

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. S开发者_开发百科ave 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.


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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜