in reply to DBI insert statement
Looking at the examples it seems the structures of the tables is the same, you are inserting a subset to the new table. If so and there isn't some other parsing happening can't you offload the whole to the database
insert into targettable select * from sourcetable where ...If target doesn't need to permanently exist you can
create targettable as (select * from sourcetable where...)Then drop the new table at end of run.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: DBI insert statement
by soonix (Canon) on Nov 22, 2016 at 19:13 UTC | |
by tweetiepooh (Hermit) on Nov 23, 2016 at 11:17 UTC | |
by erix (Prior) on Nov 23, 2016 at 14:10 UTC |
In Section
Seekers of Perl Wisdom