https://community.qlik.com/t5/Installing-and-Upgrading/resolved-compress-option-for-mysql-RDS-connection/m-p/2381815#M4178 So I'm having to run job on a server that connects to remote db server (AWS RDS). <BR />This is excruciatingly slow as I don't believe that --compress is enabled for default mysql connections in talend? <BR />For example running mysql -u*** -p*** db*** &lt; dbfile***.sql --compress vs mysql -u*** -p*** db*** &lt; dbfile***.sql. The difference between a normal test load (30 min) and a load with --compress (5min) is night and day. <BR />I was wondering if it possible to setup and mysql connection with --compress, maybe in the&nbsp; "Additional Paremters"? <BR />I have also just notice the AmazonRDS-&gt;MySQL components would these perform better? <BR />Cheers Andy Sat, 16 Nov 2024 11:17:39 GMT Anonymous 2024-11-16T11:17:39Z https://community.qlik.com/t5/Installing-and-Upgrading/resolved-compress-option-for-mysql-RDS-connection/m-p/2381815#M4178 So I'm having to run job on a server that connects to remote db server (AWS RDS). <BR />This is excruciatingly slow as I don't believe that --compress is enabled for default mysql connections in talend? <BR />For example running mysql -u*** -p*** db*** &lt; dbfile***.sql --compress vs mysql -u*** -p*** db*** &lt; dbfile***.sql. The difference between a normal test load (30 min) and a load with --compress (5min) is night and day. <BR />I was wondering if it possible to setup and mysql connection with --compress, maybe in the&nbsp; "Additional Paremters"? <BR />I have also just notice the AmazonRDS-&gt;MySQL components would these perform better? <BR />Cheers Andy Sat, 16 Nov 2024 11:17:39 GMT https://community.qlik.com/t5/Installing-and-Upgrading/resolved-compress-option-for-mysql-RDS-connection/m-p/2381815#M4178 Anonymous 2024-11-16T11:17:39Z https://community.qlik.com/t5/Installing-and-Upgrading/resolved-compress-option-for-mysql-RDS-connection/m-p/2381816#M4179 Just answering my own question again <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAB6.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/158321i00588DF41617C922/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAB6.png" alt="0683p000009MAB6.png" /></span> <BR />Useful page <A href="http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html" target="_blank" rel="nofollow noopener noreferrer">here</A>, just use " <I>useCompression</I>". <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MD50.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129251iF1F603853C81186A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MD50.png" alt="0683p000009MD50.png" /></span> <BR />I'll report back with performance gains. Fri, 13 Mar 2015 11:30:50 GMT https://community.qlik.com/t5/Installing-and-Upgrading/resolved-compress-option-for-mysql-RDS-connection/m-p/2381816#M4179 Anonymous 2015-03-13T11:30:50Z