开发者

Best Data Type for a blog article in SQL Server

Currently I'm making a blog software. One problem is that, what data type to use to store the blog articles in SQL Server. I can use varchar(MAX). But the length of each of the articles is unrestricted. So, there may be per开发者_开发技巧formance problem as SQL Server uses paging of 8k. One way out, I thought that I can make multiple database entries for a single blog article. But there is another problem to select and update (I think update will be a big problem with multiple entries.)

Can you make a suggestion regarding the schema of a blog article in Database?

Thanks in advance.

I'm using SQL Server 2008, Standard Edition currently.


Use varchar(max), if the data exceeds 8KB SQL Server will use over-flow pages, a pointer will be used on the original page in that case

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜