https://community.qlik.com/t5/Talend-Studio/Speed-up-the-Update-or-Insert-to-DBOutput/m-p/2308661#M79964 <P>Hi </P><P></P><P></P><P>Is there anyway to speed up the Update or Insert from a TDBInput ---&gt; TMap ---&gt;TDBOuput please? </P><P></P><P></P> Fri, 15 Nov 2024 22:48:06 GMT thomas_2583 2024-11-15T22:48:06Z https://community.qlik.com/t5/Talend-Studio/Speed-up-the-Update-or-Insert-to-DBOutput/m-p/2308661#M79964 <P>Hi </P><P></P><P></P><P>Is there anyway to speed up the Update or Insert from a TDBInput ---&gt; TMap ---&gt;TDBOuput please? </P><P></P><P></P> Fri, 15 Nov 2024 22:48:06 GMT https://community.qlik.com/t5/Talend-Studio/Speed-up-the-Update-or-Insert-to-DBOutput/m-p/2308661#M79964 thomas_2583 2024-11-15T22:48:06Z https://community.qlik.com/t5/Talend-Studio/Speed-up-the-Update-or-Insert-to-DBOutput/m-p/2308662#M79965 <P>Hello,</P><P>What's your current rows/s and what's your source and target DB? </P><P>As tMap is a buffer component and you can change the basic configuration to store temporary data on disk rather than in memory. For example, on tMap, click the tMap settings panel of Lookup flow and select the Store temp data option as true.</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000SqK2SAAV.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128459i6DBB70E7D743B3C6/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000SqK2SAAV.png" alt="0695b00000SqK2SAAV.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0695b00000SqK2IAAV.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156934i2F49052C782B1648/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000SqK2IAAV.png" alt="0695b00000SqK2IAAV.png" /></span>Best regards</P><P>Sabrina</P> Thu, 23 Jun 2022 06:40:28 GMT https://community.qlik.com/t5/Talend-Studio/Speed-up-the-Update-or-Insert-to-DBOutput/m-p/2308662#M79965 Anonymous 2022-06-23T06:40:28Z