in reply to DBI and DBD::Pg: Assessing Performance

There may also be improvements you could make in your database structure to speed things up. For example, if you've got a lot of indices on your tables, then this speeds up reads at the expense of slower writes. So perhaps you could improve performance of writes by removing some unused indices.

perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'
  • Comment on Re: DBI and DBD::Pg: Assessing Performance

In Section Seekers of Perl Wisdom