Cant fetch data from multiple tables at same time , reader waits for another reader to complete

Can’t fetch data from multiple tables at the same time, reader waits for another reader to complete

I have connection to MySQL DB and same schema
I am trying to read 4 tables at the same time to save time
but database reader waits for previous database reader to complete reading then it starts next table.

why this can’t happen parallel?
image

image

I can assume this is because you use legacy nodes. You need to switch to the new DB framework for parallel processing.

1 Like

Can you share me exact name of node ! or extension

Read here about new framework. You may need to reinstall JDBS so on.
https://docs.knime.com/2019-06/db_extension_guide/index.html
Also upgrade to the latest KNIME could be necessary.

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.