News for hackers. Stuff that matters.
Re:My Favorite PostgreSQL Queries and Why They Matter by Can_Not on Sunday April 15, 2018 @02:42PM (#16844163)
I don't think using a prepared statement 100 times will have anywhere close to the same performance improvement as sending one concatenated bulk update or one update set case.
Re:My Favorite PostgreSQL Queries and Why They Matter by pritambaral on Sunday April 15, 2018 @09:41PM (#16846132)
No reason why prepared statements and single-call batched-statements can't both be used together. Of course, if one method (batching statements) works well enough, there's no need for another (prepared statements) too.
Re:My Favorite PostgreSQL Queries and Why They Matter by Can_Not on Monday April 16, 2018 @12:06AM (#16846611)
In every ORM I've ever used, everything is a prepared statement by default, so I've only been comparing 100 separate database call updates vs 100 updates concatenated as a single database call and 100 updates as a single update case when, where all three were already implied prepared statements.