Yep, that's the pattern I follow. Unfortunately, the "ETL pipeline" I mentioned didn't even use transactions and was opening a new connection for every insert.

Yep, that's the pattern I follow. Unfortunately, the "ETL pipeline" I mentioned didn't even use transactions and was opening a new connection for every insert. No wonder it was slow.