Log Rows per second Inserted in DB

[MAli_Khan923132608504]

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...

[manodwhb]

@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

[MAli_Khan923132608504]

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.

[Anonymous]

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

[MAli_Khan923132608504]

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

Cany you please guide.

[Anonymous]

Hello,

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

Best regards

Sabrina