压缩SQL Server 2005的查询结果？ [英] Compress SQL Server 2005 query results?

问题描述

是否有可能通过在客户端透明的方式压缩SQL查询结果，以减少网络负载？
DB引擎：SQL Server 2005中

Is it possible to reduce network load by compressing sql query results in a transparent way for the client? DB engine : SQL Server 2005

推荐答案

没有。 SQL工作量很少结果的大小驱动。除非是一个ETL作业或数据送货，从未有一个理由退换货大结果开始。对于需要大量运到客户端的数据这些特定的情况下，有比T-SQL查询（日志传送，服务代理，复制）更好的解决方案。

No. SQL workload is rarely driven by result size. Unless is an ETL job or data shipping, there is never a reason to return a large result to start with. For those particular scenarios that need large amounts of data shipped to the client, there are better solutions than T-SQL queries (log shipping, service broker, replication).

据可尽管通过改善数据模型，架构设计和访问查询大大减少工作量。

It is possible to reduce workload dramatically though by improving data model, schema design and the access queries.

这篇关于压缩SQL Server 2005的查询结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！