Programming Circlejerk

211 readers

1 users here now

Community to talk about enlightened programming takes

Rules:

read and follow the programming.dev code of conduct
no flamewars
mark your unjerks
only programming related content allowed
link to the original source
do not mention this community in places like hackernews, lobste.rs, or the general programming communities on Lemmy where we source jerk material from.

founded 5 months ago

MODERATORS

FirstMajesticComet@programming.dev

crmsnbleyd@sopuli.xyz

crmsnbleyd@programming.dev

People often say SQL has no problem to scale but they've never actually done it (sopuli.xyz)

submitted 2 months ago by crmsnbleyd@sopuli.xyz to c/programmingcirclejerk@programming.dev

21 comments fedilink hide all child comments

URL: https://www.linkedin.com/posts/urielbitton_sql-is-not-easily-scalable-despite-what-people-activity-7315350270857666562-sbpV

you are viewing a single comment's thread
view the rest of the comments

[–] boonhet@lemm.ee 2 points 2 months ago* (last edited 2 months ago)

And if doing pagination, order by an index and add a minimum bound, instead of doing LIMIT 5000,5000.

Oh and if the query optimizer picks a bad index for what you're doing, you can force a better one.

And don't do dependent subqueries and...

Idk, this is stuff I learned in my first year or 2 at my first job in the field. And I've had people on reddit tell me I'm a programmer not a software engineer because I don't have the education so therefore I can only be a code monkey. Yet somehow Amazon pays people 5x my salary to not know how to use SQL efficiently while I'm out here building queries that show no non-index reads, sometimes in databases where I'm not even allowed to add new indexes because of legacy reasons.