Re:PostgreSQL adds support for OUT parameters in Procedures
by bhaak on Friday October 15, 2021 @07:09PM
(#28884180)
In a previous job many moons ago I was tasked with maintaining an application that used an Oracle DB with stored procedures written in Java.
The server backend was naturally in Java as well so as soon as possible I ripped it out of the db and ran it on the backend.
The code ran twice as fast.
It might have been partly due to the JVM in the db being 1.3 whereas the server had 1.4 but still, nobody bothered to measure and just assumed the code in the db running faster because it was closer to the db.
The server backend was naturally in Java as well so as soon as possible I ripped it out of the db and ran it on the backend.
The code ran twice as fast.
It might have been partly due to the JVM in the db being 1.3 whereas the server had 1.4 but still, nobody bothered to measure and just assumed the code in the db running faster because it was closer to the db.