文章存储：文件与数据库 [英] Article Storage: Files vs. Database

问题描述

我想建立一个包含许多文章的网站。两种基本的

方法是将文章存储在aspx文件中，可能由数据库索引

，或者将文章文本存储在数据库中。


将它们存储在文件中的一些优点是简单和高效。


将它们存储在数据库中的一些优点是易于进行某些操作，

以及使用SQL Server 2005文本索引实现搜索的选项。


其他人可以考虑在这两种方法之间进行选择

方法？


谢谢。


Jonathan

解决方案

我们几乎专门为这种东西使用数据库。它更容易搜索，索引等等，并且内容可以填充到模板化的
文章页面中。它也可以通过部分页面缓存进行缓存。

Peter


Jonathan Wood < jw *** @ softcircuits.com写信息

新闻：％2 **************** @ TK2MSFTNGP02.phx.gbl ...

我想建立一个包含许多文章的网站。两种基本的

方法是将文章存储在aspx文件中，可能由数据库索引
，或者将文章文本存储在数据库中。


将它们存储在文件中的一些优点是简单和高效。


将它们存储在数据库中的一些优点是一些便宜的

操作，以及使用SQL Server 2005文本索引来实现搜索的选项。


其他人可以考虑在这两者之间进行选择吗？ br $>
接近？


谢谢。


Jonathan

是的，这些肯定是一些优点。你有没有使用SQL

Server 2005的全文索引呢？对于基于文件的文章，实施

搜索是一件痛苦的事。


此外，如果能够看到你所指的网站的一些样本/>
其中任何一个都是公开的。


Jonathan


" Peter Bromberg [C＃MVP]" < pb ******* @ nospammin.yahoo.com在留言中写道

news：83 ********************* ************* @ microsof t.com ...

我们几乎专门为这种东西使用数据库。 。搜索，索引等更容易

，内容可以填入

" templatized"文章页面。它也可以通过部分页面缓存

缓存。

Peter


" Jonathan Wood" < jw *** @ softcircuits.com写信息

新闻：％2 **************** @ TK2MSFTNGP02.phx.gbl ...

>我想建立一个包含许多文章的网站。两种基本的方法是将文章存储在aspx文件中，可能由数据库索引，或者将文章文本存储在数据库中。

存储它们的一些优点文件中的简单性和高效性。

将它们存储在数据库中的一些优点是易于操作，并且可以选择使用SQL Server 2005文本索引来实现搜索。

其他人可以考虑选择这两种方法吗？

谢谢。

Jonathan

实现搜索功能很痛苦。你可以自己动手或者获得一些第三方解决方案，比如dtSearch或开源（只是googleserarch

引擎开源 


但根据我的经验，SQL服务器的全文并没有做得很好。


George。

" Jonathan Wood" < jw *** @ softcircuits.com写信息

新闻：eL **************** @ TK2MSFTNGP05.phx.gbl ...

是的，这些肯定是一些优点。您是否已经使用了

SQL Server 2005的全文索引了吗？使用基于文件的文章，

实现搜索是一件痛苦的事。


此外，如果能够看到你所指的网站的一些样本/>
其中任何一个都是公开的。


Jonathan


" Peter Bromberg [C＃MVP]" < pb ******* @ nospammin.yahoo.com在留言中写道

news：83 ********************* ************* @ microsof t.com ...

>我们几乎专门为这种类型的数据库使用数据库。东西" ;.它更容易搜索，索引等，并且内容可以填充到模板化的内容中。文章页面。它也可以通过部分页面缓存来缓存。
Peter

Jonathan Wood < jw *** @ softcircuits.com写信息
新闻：％2 **************** @ TK2MSFTNGP02.phx.gbl ...
< blockquote class =post_quotes>
>>我想建立一个包含很多文章的网站。两种基本的方法是将文章存储在aspx文件中，可能由数据库索引，或者将文章文本存储在数据库中。

存储它们的一些优点文件中的简单性和高效性。

将它们存储在数据库中的一些优点是易于操作，并且可以选择使用SQL Server 2005文本索引来实现搜索。

其他人可以考虑选择这两种方法吗？

谢谢。

Jonathan

I''d like to build a Website that contains many articles. Two basic
approaches are to either store the articles in aspx files, possibly indexed
by the database, or to store the article text in the database.

Some advantages of storing them in files are simplicity, and efficiency.

Some advantages of storing them in the database are ease of some operations,
and the option of using SQL Server 2005 text index to implement search.

Can anyone else offer some considerations for choosing between these two
approaches?

Thanks.

Jonathan

解决方案

We use databases almost exclusively for this kind of "stuff". Its easier to
search, index, etc. and the content can be populated into a "templatized"
article page. It can also be cached via Partial page caching.
Peter

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

I''d like to build a Website that contains many articles. Two basic
approaches are to either store the articles in aspx files, possibly
indexed by the database, or to store the article text in the database.

Some advantages of storing them in files are simplicity, and efficiency.

Some advantages of storing them in the database are ease of some
operations, and the option of using SQL Server 2005 text index to
implement search.

Can anyone else offer some considerations for choosing between these two
approaches?

Thanks.

Jonathan

Yeah, these are definitely some of the advantages. Have you made use of SQL
Server 2005''s full-text indexing yet? With file-based articles, implementing
search is a pain.

Also, would love to see some samples of the sites you are referring to if
any of them are public.

Jonathan

"Peter Bromberg [C# MVP]" <pb*******@nospammin.yahoo.comwrote in message
news:83**********************************@microsof t.com...

We use databases almost exclusively for this kind of "stuff". Its easier
to search, index, etc. and the content can be populated into a
"templatized" article page. It can also be cached via Partial page
caching.
Peter

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>I''d like to build a Website that contains many articles. Two basic
approaches are to either store the articles in aspx files, possibly
indexed by the database, or to store the article text in the database.

Some advantages of storing them in files are simplicity, and efficiency.

Some advantages of storing them in the database are ease of some
operations, and the option of using SQL Server 2005 text index to
implement search.

Can anyone else offer some considerations for choosing between these two
approaches?

Thanks.

Jonathan

Implementing search functionality is pain.You might do it yourself or get
some third party solution like dtSearch or open source (just google "serarch
engine open source")

But from my experience the SQL server''s full-text do not do a good job.

George.
"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:eL****************@TK2MSFTNGP05.phx.gbl...

Yeah, these are definitely some of the advantages. Have you made use of
SQL Server 2005''s full-text indexing yet? With file-based articles,
implementing search is a pain.

Also, would love to see some samples of the sites you are referring to if
any of them are public.

Jonathan

"Peter Bromberg [C# MVP]" <pb*******@nospammin.yahoo.comwrote in message
news:83**********************************@microsof t.com...

>We use databases almost exclusively for this kind of "stuff". Its easier
to search, index, etc. and the content can be populated into a
"templatized" article page. It can also be cached via Partial page
caching.
Peter

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>>I''d like to build a Website that contains many articles. Two basic
approaches are to either store the articles in aspx files, possibly
indexed by the database, or to store the article text in the database.

Some advantages of storing them in files are simplicity, and efficiency.

Some advantages of storing them in the database are ease of some
operations, and the option of using SQL Server 2005 text index to
implement search.

Can anyone else offer some considerations for choosing between these two
approaches?

Thanks.

Jonathan

这篇关于文章存储：文件与数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！