Need a lot more detail as asked above. What are the "Get Variables"? Base on youyr question it seems like actually the row data from the prior transform. Then you replace variables in the stream. Why are you blocking and what are those settings? Are you blocking for all input rows 100k+? That will cause memory issues and could create thrashing on the input stream because you cannot output the rows.
------------------------------
Stephen Donovan
General IT Consulting & Implementation Pre-eminent Professional
Hitachi Vantara
------------------------------
Original Message:
Sent: 06-05-2023 15:20
From: Petr Prochazka
Subject: Table Input takes too long
What are you meaning Pentaho issue too? I don't understand it.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 06-01-2023 15:34
From: Petr Prochazka
Subject: Table Input takes too long
And strange is that table input step has hop from previous step but doesn't load any row.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 06-01-2023 12:27
From: Daniel Batista
Subject: Table Input takes too long
I have a transformation that receive input rows from previous transformation, this inputs rows are used to replace variable in query. Sometimes my table input runs for too long, it takes til 1h to get rows from query, but I don't know where's to find some solution.
Please, anyone could help me?
------------------------------
Daniel Batista
Systems Engineer
Embracon
------------------------------