https://community.qlik.com/t5/Talend-Studio/Improve-performance-of-db2-to-csv-load/m-p/2289777#M63128 <P>Hi everyone,</P> <P>&nbsp;</P> <P>I have little more than 3 million records in my source db2 table. I m writing this to a csv file and it took 40 minutes for 2 million records and then failed with java heap space error. (around 600 records/s)</P> <P>Note : I'm not creating the job in my local directory, in turn sending the data through output stream and creating the file on dropbox.</P> <P>&nbsp;</P> <P>Can someone suggest me ways to increase performance in this case?</P> <P>&nbsp;</P> <P>Thanks in advance for your help</P> Sat, 16 Nov 2024 05:56:19 GMT nivedhitha 2024-11-16T05:56:19Z https://community.qlik.com/t5/Talend-Studio/Improve-performance-of-db2-to-csv-load/m-p/2289777#M63128 <P>Hi everyone,</P> <P>&nbsp;</P> <P>I have little more than 3 million records in my source db2 table. I m writing this to a csv file and it took 40 minutes for 2 million records and then failed with java heap space error. (around 600 records/s)</P> <P>Note : I'm not creating the job in my local directory, in turn sending the data through output stream and creating the file on dropbox.</P> <P>&nbsp;</P> <P>Can someone suggest me ways to increase performance in this case?</P> <P>&nbsp;</P> <P>Thanks in advance for your help</P> Sat, 16 Nov 2024 05:56:19 GMT https://community.qlik.com/t5/Talend-Studio/Improve-performance-of-db2-to-csv-load/m-p/2289777#M63128 nivedhitha 2024-11-16T05:56:19Z