Re: useCompression
Posted by: Mark Matthews
Date: May 02, 2005 05:04PM

Greg Steele wrote:
> Hello,
> I've been doing some experimenting with the
> useCompression property that can be assigned to a
> Connection. It appears that data sent from the
> server is compressed, but date inserted from the
> client is not. I'm transmitting some pretty large
> files, and this could make a big difference.
> Anybody know how to enable bidirectional
> compression?
> My server is running MySQL 4.1, and I'm using
> J/Connector 3.0.16.
> Thanks!


The compression automatically works in both directions. However, if the client determines that the data would take up more room compressed, then it sends the original data (which can happen with some files). It also doesn't compress packets below some threshold.

Have you tried the same statements using the "mysql" command-line client with --compress enabled and looked to see what it is sending?


Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools

Options: ReplyQuote

Written By
May 02, 2005 02:19PM
Re: useCompression
May 02, 2005 05:04PM
May 02, 2005 05:13PM
May 03, 2005 07:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.