topic Re: Log Rows per second Inserted in DB in Talend Studio

Log Rows per second Inserted in DB

MAli_Khan923132608504 — Sat, 16 Nov 2024 01:44:19 GMT

I have created a job tDBInput->tmap->tDBOutput

I want to log the number of rows inserted in Database in one second.

Thanks in advance...

Re: Log Rows per second Inserted in DB

manodwhb — Wed, 05 Aug 2020 11:06:57 GMT

@Muhammad Ali Khan , we do not have a direct component to check that how many records inserted per second. May you need to run the manual query at DB side to check that. but when you are running from Talend Studio you will get to know that how many records are processing per seconds from component to component.

Thanks,

Manohar

Re: Log Rows per second Inserted in DB

MAli_Khan923132608504 — Wed, 05 Aug 2020 11:28:11 GMT

as per my opinion ,The rows per second written on every component is coming from some variables or from some where. how can i save and log it on every second.

Re: Log Rows per second Inserted in DB

Anonymous — Thu, 06 Aug 2020 06:14:43 GMT

Hello,

So far, Nb_LINE is used to count the total number of records have been proceed. For example, when inserted item is chosen, a global variable ((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED")) will be available, which counts the total number of records have been inserted into database.

Here is a component tFlowMeterwhich counts the number of lines in the specified flow.

This number of lines is getting back by tFlowMeter in order to be add to log data!

For more information about this component, please have a look at this related scenario: TalendHelpCenter:Catching flow metrics from a Job

Best regards

Sabrina

Re: Log Rows per second Inserted in DB

MAli_Khan923132608504 — Thu, 06 Aug 2020 06:29:41 GMT

In the tflowMeterCatcher i am getting total Count of Rows. I want Rows inserted per second.

Cany you please guide.

Re: Log Rows per second Inserted in DB

Anonymous — Thu, 06 Aug 2020 09:13:16 GMT

Hello,

There is not a specific component to check that how many records inserted per second.

Best regards

Sabrina