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.)
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
精彩评论