Drew@sopuli.xyzM to Programming Circlejerk@programming.dev · 2 months agoPeople often say SQL has no problem to scale but they've never actually done itsopuli.xyzimagemessage-square21fedilinkarrow-up146arrow-down10file-text
arrow-up146arrow-down1imagePeople often say SQL has no problem to scale but they've never actually done itsopuli.xyzDrew@sopuli.xyzM to Programming Circlejerk@programming.dev · 2 months agomessage-square21fedilinkfile-text
URL: https://www.linkedin.com/posts/urielbitton_sql-is-not-easily-scalable-despite-what-people-activity-7315350270857666562-sbpV
minus-squaremvirts@lemmy.worldlinkfedilinkarrow-up16·2 months ago😅 what year is this guy living in? SQL has scaled, probably better than any other software paradigm.
minus-squareKichae@lemmy.calinkfedilinkEnglisharrow-up12·2 months 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·2 months 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!