Use ‘select’ account or Auxiliary database if no updates are expected.

Put ‘commit’ at regular intervals; for example, after 5K records. This will ensure that other jobs/online/applications running in the same database do not fail, otherwise they could cause major issues in Production.