[R] Compressed communication with DB using RMySQL?

[David James]

Uri wrote:
> Dear All,
> I have a setup where R pulls entries from a MySQL db server.  I wanted
> to know whether the R interface can pull encrypted / compressed data
> from MySQLD.  MySQL supports compressed communication on the server
> side, but I couldn't find any references to such options on the client
> (RMySQL) side.

Right, this is not properly documented (buried in ?mysqlNewConnection).
You can simply add the argumet client.flag = 32 to dbConnect(), e.g.,

   con <- dbConnect(MySQL(), ..., client.flag=32)

The number 32 comes from the mysql_com.h version 4.1.17 header file
#define CLIENT_COMPRESS		32	/* Can use compression protocol */

I'd be curious to know whether you find compressed connections 
significantly faster over raw connections.

Hope this helps,

--
David

> 
> Best,
> Uri Hasson.
> ---
> Uri Hasson.
> Brain Research Imaging Center
> The University of Chicago.
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html