https://community.qlik.com/t5/Talend-Studio/Faster-loading-of-bulky-table/m-p/2364693#M128406 Hi, <BR />Have you checked ELT components for faster data load?<BR />Have you used the bulkload option for faster data load.?<BR />You can also try to bulk load to and from csv file.<BR />Thanks<BR />Vaibhav Mon, 28 Apr 2014 11:47:10 GMT Anonymous 2014-04-28T11:47:10Z https://community.qlik.com/t5/Talend-Studio/Faster-loading-of-bulky-table/m-p/2364692#M128405 Hi All, <BR />I am using Enterprise version for developing ETL jobs to load data from MSSQL Server (source) to MySQL-InnoDB engine (Destination). <BR />However, a table which has multiple text columns (VARCHAR (900), Text, etc) and over 50 million records, takes almost 48 hours to load in MySQL. <BR />I am using simple tMSSQLInput and tMySQLOutput tasks to load data. I have increased the commit size and also enabled the Extend insert where No. Of Rows per insert has also been increased. Also allocated 20GB memory in JVM arguments. Still I am observing the same execution time. <BR />What else could be done to tune this job so that it loads data as fast as possible ? Mon, 28 Apr 2014 11:41:46 GMT https://community.qlik.com/t5/Talend-Studio/Faster-loading-of-bulky-table/m-p/2364692#M128405 Anonymous 2014-04-28T11:41:46Z https://community.qlik.com/t5/Talend-Studio/Faster-loading-of-bulky-table/m-p/2364693#M128406 Hi, <BR />Have you checked ELT components for faster data load?<BR />Have you used the bulkload option for faster data load.?<BR />You can also try to bulk load to and from csv file.<BR />Thanks<BR />Vaibhav Mon, 28 Apr 2014 11:47:10 GMT https://community.qlik.com/t5/Talend-Studio/Faster-loading-of-bulky-table/m-p/2364693#M128406 Anonymous 2014-04-28T11:47:10Z