We help IT Professionals succeed at work.

Client - server compression

NickRepin
NickRepin asked
on
It seems that the MS SQL server and clients exchange data without any compression. Is there any way to enable compression for network libraries to reduce the network traffic?
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
As far as i know, SQL does not have this option.

Listening & Learning

Commented:
angellIII is right, SQL does not have that option.
I ask to a MS guy in Redmond, and he told me that there is no compression option at TDS level, net-libraries level, or ole-db level, etc.
I think your question's goal is to reduce network traffic betwen SQL Server and client. But "Reduce network traffic" could be applied to a lot of cases (for example I could try to reduce network traffic betwen Outlook & Exchange).
Then you could try some kind of general software compression, but as far as I know, the TCP/IP stack doesn't support compression either (the only compression I remember is in RAS).
So probably there is a hardware option, I am not sure. I think this guys have something: http://www.peribit.com.
Hope this helps.
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
Hi,

If you optimise your queries and procedures so that most of the processing is done on the server then this by itself will eliminate a lot of network traffic.

Using views and stored procedures to return the data can be more efficient than letting crystal reports calculate a sum at the client.

Having used a client/server SQL application over modem I can say that it is already pretty network efficient. That is, I could almost run some querys as fast over the modem as if I was directly on the server.

That is, looking to compress the network traffic is imho the wrong end of the problem to start at.

Regards
  David

Author

Commented:
Thank you all guys for the input.

If you don't mind, I will create 3 dummy questions 75 points each for everyone.
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
You should then not delete this question, but ask Community Support to move the q to PAQ, so it can be read again.
CHeers
NickRepin:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
Commented:
Question PAQ'd and points refunded.

RomMod
Community Support Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.