695
Sometimes, it's backwards (sh.itjust.works)
submitted 2 years ago* by to c/programmer_humor@programming.dev
188 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] 24 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
    •
  • [–] 6 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
    •
  • [+] 2 points 2 years ago (1 child)
    [deleted]
  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 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