oracle connector with db looping

[ipazin]

Hello @likhangy,

according to this topic this is expected to be slow in certain cases:

DB Looping Node

I have just tried using the new DB Looping Node. I am finding that it suffers the same limitations as legacy approaches; namely that it cannot accept a large list for the IN statement. Therefore a loop of several (or many times) over the database is still necessary, which is of course very slow. Am I missing something? Can a large list be used and loop over the database only once?

You can always read data into KNIME (460k is rather small table) and then use Reference Row Filter node to filter it. Should be much faster.

Br,
Ivan