[resolved] --compress option for mysql (RDS) connection?

One Star

[resolved] --compress option for mysql (RDS) connection?

So I'm having to run job on a server that connects to remote db server (AWS RDS).
This is excruciatingly slow as I don't believe that --compress is enabled for default mysql connections in talend?
For example running mysql -u*** -p*** db*** < dbfile***.sql --compress vs mysql -u*** -p*** db*** < dbfile***.sql. The difference between a normal test load (30 min) and a load with --compress (5min) is night and day.
I was wondering if it possible to setup and mysql connection with --compress, maybe in the  "Additional Paremters"?
I have also just notice the AmazonRDS->MySQL components would these perform better?
Cheers Andy

Accepted Solutions
One Star

Re: [resolved] --compress option for mysql (RDS) connection?

Just answering my own question again Smiley Tongue
Useful page here, just use "useCompression".

I'll report back with performance gains.

All Replies
One Star

Re: [resolved] --compress option for mysql (RDS) connection?

Just answering my own question again Smiley Tongue
Useful page here, just use "useCompression".

I'll report back with performance gains.