Fork me on GitHub
#sql
<
2021-07-09
>
zebu07:07:18

I’m trying to write code to copy data from one table to another using next.jdbc. I can just use reduce with plan to do insert each record one at a time but struggling how i can wait for say 1000 records before doing insert to destination table, using this reduce way.

Russell Mull17:07:08

Is something like insert into dest select * from source (or a variant) not appropriate? I'd expect that to be many times faster.

zebu00:07:44

Sorry i should have mentioned that the source table and destination table are in different db servers