5 ms·
It's more based on the assumption that the limitations of MySQL should apply to all databases. I've worked 2 places with Oracle stored procedures. At both pla
by jbooth 15y ago
It's more based on the assumption that the limitations of MySQL should apply to all databases.
I've worked 2 places with Oracle stored procedures. At both places, they were a giant nonperformant mess of spaghetti that could never be cleaned up because changing things == breaking things. And since all of the application logic had been written as transactional SQL with lots of joins over normalized tables, it was gridlock heaven inside the DB and adding more cores to the single machine barely even helped.
- gaius 15y agoYou can write bad code in any language!
- jbooth 15y agoYeah but that's a total nonpoint. Are you arguing we should all use COBOL and every other stupid-ass approach, as well?
- InclinedPlane 15y agoI think he's saying that anecdotes are not necessarily the most valid form of data for making decisions.
- jbooth 15y agoWell, it's a subjective judgment, and the anecdotes I've seen/heard are 90% in one direction, with the other 10% coming from people who make their living dealing with PL/SQL. Good apocryphal quote, it's impossible to convince someone of something if their job depends on it not being true.