CODEWITHSUNDEEP
sql-server
ebattulga
ebattulga

Reputation: 11011

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. 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.

Upvotes: 0

Views: 256

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294487

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.

Upvotes: 1

Related Questions