Drew@sopuli.xyzM to Programming Circlejerk@programming.dev · 15 days agoPeople often say SQL has no problem to scale but they've never actually done itsopuli.xyzimagemessage-square21linkfedilinkarrow-up117arrow-down10file-text
arrow-up117arrow-down1imagePeople often say SQL has no problem to scale but they've never actually done itsopuli.xyzDrew@sopuli.xyzM to Programming Circlejerk@programming.dev · 15 days agomessage-square21linkfedilinkfile-text
URL: https://www.linkedin.com/posts/urielbitton_sql-is-not-easily-scalable-despite-what-people-activity-7315350270857666562-sbpV
minus-squaremvirts@lemmy.worldlinkfedilinkarrow-up12·15 days ago😅 what year is this guy living in? SQL has scaled, probably better than any other software paradigm.
minus-squareKichae@lemmy.calinkfedilinkEnglisharrow-up12·13 days agoYes, but if I do 80 joins and don’t specify join conditions, things get, like, super slow, Scoobs!
minus-squareI Cast Fist@programming.devlinkfedilinkarrow-up1·13 days agoThat’s why you should only left outer inner right join with a recursive select!
😅 what year is this guy living in? SQL has scaled, probably better than any other software paradigm.
Yes, but if I do 80 joins and don’t specify join conditions, things get, like, super slow, Scoobs!
That’s why you should only left outer inner right join with a recursive select!