in reply to Posgres batch read with DBI?
cut down on db transaction overhead.
Depending on what you're up to, you can also set AutoCommit off, then count changed records while you process, and commit every N changes (every 1000 or so). It may be simpler.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Posgres batch read with DBI? - ( PostgreSQL )
by jszinger (Scribe) on Jan 27, 2021 at 22:43 UTC | |
by Marshall (Canon) on Jan 30, 2021 at 05:37 UTC |
In Section
Seekers of Perl Wisdom