February 15, 2011
News - Some MariaDB -> Postgr…
Stored procedures in postgres can be a very good solution for gaining tons of performance because postgres has a bit more transaction overhead than a dumb database like mysql. Using a stored procedure gets around this by putting a bunch of work into a single transaction.
I disagree that it makes things less portable, it just makes things less portable to a database that doesn’t also have a decent procedure language. If you were to port this data to oracle or even mssql, you simply write a proc in that database to produce the same data and press on.
The point is that moving from mysql to postgres isn’t super difficult (though it is time consuming), but moving from postgres back to mysql is pretty much impossible.
Forgot your password?
No account? Register one!