▲ 705 ▼ Sometimes, it's backwards (sh.itjust.works) submitted 2 years ago* by 0x4E4F@sh.itjust.works to c/programmer_humor@programming.dev 188 comments fedilink hide all child comments
[–] 0x4E4F@sh.itjust.works [S] 22 points 2 years ago (1 child) Yep, unrealistic expectations. Or "you need a 12th gen i7 to run this thing"... the thing is a glorified Avidemux. permalink fedilink source parent hideshow 2 child comments replies: [–] UnderpantsWeevil@lemmy.world 25 points 2 years ago (2 children) Christ, if you could see the abysmal efficiency of business tier SQL code being churned out in the Lowest Bidder mines overseas... Using a few terrabytes of memory and a stack of processors as high as my knee so they can recreate Excel in a badly rendered .aspx page built in 2003. permalink fedilink source parent hideshow 4 child comments replies: [–] fibojoly@sh.itjust.works 7 points 2 years ago (1 child) We have a table with literally three columns. One is an id, another a filename and a third a path. Guess which one was picked as the primary key? Never seen something so stupid in 28 years of computing. Including my studies. permalink fedilink source parent hideshow 2 child comments replies: [–] UnderpantsWeevil@lemmy.world 3 points 2 years ago Well, you don't want to waste space by adding the same file path twice permalink fedilink source parent [+] ugo@feddit.it 2 points 2 years ago (1 child) [deleted] permalink fedilink source parent hideshow 2 child comments replies: [–] UnderpantsWeevil@lemmy.world 1 point 2 years ago Oh yeah, I love people who stick SQL lookups in a For Loop. Even better, the coder who puts conditional if (but no then/else) clauses around a dozen raw text execution commands that fire in sequence. So you're making six distinct lookups per iteration rather than answering your question in a single query and referencing the results from memory. Internal screaming permalink fedilink source parent
[–] UnderpantsWeevil@lemmy.world 25 points 2 years ago (2 children) Christ, if you could see the abysmal efficiency of business tier SQL code being churned out in the Lowest Bidder mines overseas... Using a few terrabytes of memory and a stack of processors as high as my knee so they can recreate Excel in a badly rendered .aspx page built in 2003. permalink fedilink source parent hideshow 4 child comments replies: [–] fibojoly@sh.itjust.works 7 points 2 years ago (1 child) We have a table with literally three columns. One is an id, another a filename and a third a path. Guess which one was picked as the primary key? Never seen something so stupid in 28 years of computing. Including my studies. permalink fedilink source parent hideshow 2 child comments replies: [–] UnderpantsWeevil@lemmy.world 3 points 2 years ago Well, you don't want to waste space by adding the same file path twice permalink fedilink source parent [+] ugo@feddit.it 2 points 2 years ago (1 child) [deleted] permalink fedilink source parent hideshow 2 child comments replies: [–] UnderpantsWeevil@lemmy.world 1 point 2 years ago Oh yeah, I love people who stick SQL lookups in a For Loop. Even better, the coder who puts conditional if (but no then/else) clauses around a dozen raw text execution commands that fire in sequence. So you're making six distinct lookups per iteration rather than answering your question in a single query and referencing the results from memory. Internal screaming permalink fedilink source parent
[–] fibojoly@sh.itjust.works 7 points 2 years ago (1 child) We have a table with literally three columns. One is an id, another a filename and a third a path. Guess which one was picked as the primary key? Never seen something so stupid in 28 years of computing. Including my studies. permalink fedilink source parent hideshow 2 child comments replies: [–] UnderpantsWeevil@lemmy.world 3 points 2 years ago Well, you don't want to waste space by adding the same file path twice permalink fedilink source parent
[–] UnderpantsWeevil@lemmy.world 3 points 2 years ago Well, you don't want to waste space by adding the same file path twice permalink fedilink source parent
[+] ugo@feddit.it 2 points 2 years ago (1 child) [deleted] permalink fedilink source parent hideshow 2 child comments replies: [–] UnderpantsWeevil@lemmy.world 1 point 2 years ago Oh yeah, I love people who stick SQL lookups in a For Loop. Even better, the coder who puts conditional if (but no then/else) clauses around a dozen raw text execution commands that fire in sequence. So you're making six distinct lookups per iteration rather than answering your question in a single query and referencing the results from memory. Internal screaming permalink fedilink source parent
[–] UnderpantsWeevil@lemmy.world 1 point 2 years ago Oh yeah, I love people who stick SQL lookups in a For Loop. Even better, the coder who puts conditional if (but no then/else) clauses around a dozen raw text execution commands that fire in sequence. So you're making six distinct lookups per iteration rather than answering your question in a single query and referencing the results from memory. Internal screaming permalink fedilink source parent