Streaming not working while in database

I’m trying to concatenate two databases one with around 30 million rows and the other with 1 million. Trying tro reduce the time I´m using the following scheme:

image

Looks like it needs to read the full databases and no improvement will be made. Am I right?

@christianlondon welcome to the KNIME forum.

Does it work at all. The 30 million will have to be read anyway.

Are these tables from the same database (what kind of DB are we talking)? Would a UNION or INSERT statement help to do the concatenation in the database?

1 Like