All the Perl that's Practical to Extract and Report

Note to self #392

djberg96 on 2004-05-06T19:13:21

Beware of adding insert triggers in Oracle. They can KILL performance.

Note: A mere 30,000 row insert caused an IO error.

Interesting...

Dom2 on 2004-05-06T21:21:04

I was just having this conversation today, but about PostgreSQL. It was all conversation, no facts. But I do wonder whether the participants were coloured by experience of other databases. I'll have to measure postgres to see how badly triggers affect insert performance there.

-Dom

Re:Interesting...

djberg96 on 2004-05-06T21:41:09

To be fair, I think our IO limits are sucky and we definitely need to have a conversation with the DBA because we're hitting IO limits on some other updates that don't involve the trigger (which we dropped btw). But, we'll see.