Can you create branches of the workflow dynamically for posting multiple queries to the db?

[d3n1s]

Hi guys,

I am trying to develop a workflow that takes as parameter a list of N products and posts N queries in parallel to the database.

We believe that posting N queries might be faster than posting one query with N products in.

Is such a thing possible in KNIME?

Even if this use case proves us wrong, knowing that you can generate parts of the workflow dynamically might be useful in the future.

Thanks in advance,
Denis

[mlauber71]

@d3n1s you could try and create a workflow where a database query would be sent thru parallel chunks. The performance would depend on whether the database would support several accesses at the same time

KNIME Parallel Chunk Loop Nodes

Parallel execution in Knime

Hi @yunusEG, Regarding the loop, Have you tried “Parallel Chunk Start”? You can use Table Row to Variable after the loop start to convert table attributes to flow variables. Just remember to set the chunk count equal to the number of the rows in your data set. Here is an example: parallel_chunk_loop.knwf (30.9 KB)