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?
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?