问题描述
所以我有一个应用程序,它在 SQL Server 2008 R2 的文本字段中存储大量文本.我每天要添加大约 5000 条记录,而且还会增加.字段中的数据量可以在 4 KB 到 100 KB 之间.
我可以将字段更改为 blob 字段并在其中存储字节流(例如压缩文本),但我想知道是否有任何可以在 SQL Server 2k8 中使用的压缩选项(也许是专门设计的)用于存储大量文本?)我可以直接使用 SQL Server 吗?
谢谢
注意:
关于的兼容性文件流:
- FILESTREAM 功能适用于所有版本的 SQL Server 2008,包括 SQL Server Express.
- SQL Server Express 数据库有 4 GB 的限制;但是,此限制不适用于存储在 SQL Server Express 数据库中的 FILESTREAM 数据.
但是您需要开发者版"或企业版"用于行/页压缩.
alter table pagevisit rebuild with (data_compression=page);
消息 7738,级别 16,状态 2,第 2 行无法为对象启用压缩'页面访问'.仅 SQL 服务器企业版支持压缩.
So I have an application that stores a lot of text in a text field in SQL Server 2008 R2. I'm adding about 5000 records a day, and that is going to grow. The amount of data in the field can be between 4 KB and 100 KB.
I can change the field to be a blob field and store a byte stream in there (eg. zipped text), but I'm wondering if there is any compression option that I can use in SQL Server 2k8 (perhaps something designed for storing a lot of text?) that I could leverage using SQL Server out of the box?
thanks
Note:
Regarding compatibility of FILESTREAMS :
- FILESTREAM feature is available with all versions of SQL Server 2008, including SQL Server Express.
- SQL Server Express database has a 4 GB limitation; however this limitation does not apply to the FILESTREAM data stored in a SQL Server Express database.
However you need 'Developer Edition' or 'Enterprise Edition' for Row / Page compression.
alter table pagevisit rebuild with (data_compression=page);
这篇关于在 Sql Server 2k8 R2 中压缩文本字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!