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:
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?
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.