Come for the quick hacks, stay for the epiphanies. | |
PerlMonks |
Re: Posgres batch read with DBI? - ( PostgreSQL )by erix (Prior) |
on Jan 27, 2021 at 07:23 UTC ( [id://11127508]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|