News for hackers. Stuff that matters.

A comment on Are triggers really that slow in Postgres?. Parent comment

Re:Are triggers really that slow in Postgres? by matte_black on Wednesday May 23, 2018 @12:28AM (#17131474)
This is just a limitation of ORMs. After a certain complexity you really should just be making direct queries to your database and not relying on ORMs.
[ Parent | on HN ]
Re:Are triggers really that slow in Postgres? by lostapathy on Wednesday May 23, 2018 @07:38AM (#17133258)
That’s the thing -what the app tier was doing wasn’t to complex for an ORM. Not by a long ahot.

The triggers that caused us problems generally came about to cover unrelated dba laziness and needed removed for sanity reasons anyway.

I am not arguing there cannot be a good case for triggers, just that when abused they cause a certain level of hell that is not worth it.

[ Parent | on HN ]