https://community.qlik.com/t5/Talend-Studio/Poor-Performance-when-using-tStatCatcher/m-p/2315880#M86486 <P>I have a long job with many sub-jobs. It takes about 300 seconds to execute. I wanted to collect some stats on the job and certain components, so I added a tStatCatcher component like this:</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AcRGxAAN.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133084i3496776B746F519D/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AcRGxAAN.png" alt="0693p00000AcRGxAAN.png" /></span></P><P>This makes the job take over 1000 seconds, and it appears that the stat Catcher starts and stops for each row written to the DB. I changed it to use a shared connection so it didn't have to make the connection each time, but that seems to have no effect. Is tStatCatcher just a bad component, or is there a way to make it perform better?</P> Sat, 16 Nov 2024 00:53:49 GMT MarkM1 2024-11-16T00:53:49Z https://community.qlik.com/t5/Talend-Studio/Poor-Performance-when-using-tStatCatcher/m-p/2315880#M86486 <P>I have a long job with many sub-jobs. It takes about 300 seconds to execute. I wanted to collect some stats on the job and certain components, so I added a tStatCatcher component like this:</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AcRGxAAN.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133084i3496776B746F519D/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AcRGxAAN.png" alt="0693p00000AcRGxAAN.png" /></span></P><P>This makes the job take over 1000 seconds, and it appears that the stat Catcher starts and stops for each row written to the DB. I changed it to use a shared connection so it didn't have to make the connection each time, but that seems to have no effect. Is tStatCatcher just a bad component, or is there a way to make it perform better?</P> Sat, 16 Nov 2024 00:53:49 GMT https://community.qlik.com/t5/Talend-Studio/Poor-Performance-when-using-tStatCatcher/m-p/2315880#M86486 MarkM1 2024-11-16T00:53:49Z https://community.qlik.com/t5/Talend-Studio/Poor-Performance-when-using-tStatCatcher/m-p/2315881#M86487 <P>Hello,</P><P>What's the transformation are you using in your tMap? The Stats &amp; Logs preferences can be set for all jobs in a project via Project Settings, or separately for individual jobs via the Job tab.</P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AcWF6AAN.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154607i388E10531BCB3BD1/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AcWF6AAN.png" alt="0693p00000AcWF6AAN.png" /></span>Best regards</P><P>Sabrina</P> Tue, 29 Dec 2020 05:07:12 GMT https://community.qlik.com/t5/Talend-Studio/Poor-Performance-when-using-tStatCatcher/m-p/2315881#M86487 Anonymous 2020-12-29T05:07:12Z