I have a web server that is far (geographically) from the database it uses. I notice when a db query returns many records it takes a long time to send that data to the web server...
Is there a way to implement data compression between the client and sql db?
Can this be done at the TCP level or sql/server level?
web server client is running on Win 2008 Web SP2/64-bit.
sql server 2008 std is running on Win 2008 Std SP2/64-bit