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

[Anonymous]

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

[Anonymous · Accepted solution]

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

I'll report back with performance gains.