• BoofStroke@sh.itjust.worksEnglish
    4·
    10 months ago

    Yet it’s the sysadmin who gets blamed, not the developer. “How can you tune the database so this doesn’t happen?”

    • Tartas1995@discuss.tchncs.de
      2·
      10 months ago

      I am telling you this because hopefully it will make you feel a little better. Our head of it blames devs for slow queries.

      • lightnegative@lemmy.world
        0·
        10 months ago

        Devs who don’t understand how SQL or relational databases work write absolute abortions of queries.

        9 times out of 10 - yes it is absolutely the devs. I say that as the dev who gets tasked with analysing why these shitty queries from our low budget outsourced labour are so slow

          • lightnegative@lemmy.world
            0·
            10 months ago

            Err, no? At what point did I claim to be an expert?

            It doesn’t take a genius to realise that serving 100-record chunks of a billion record dataset using limit 100 offset 582760200 is never gonna perform well

            Or that converting indexed time columns to strings and doing string comparisons on them makes every query perform an entire table scan, which is obvious if you actually take the time to look at the query plan (spoiler: they don’t)

            “Why can’t the system handle more than 2 queries per second? This database sucks”

            • Tartas1995@discuss.tchncs.de
              0·
              10 months ago

              I didn’t mean it so serious. I just tried to express that you seem to have experience with it and I am wondering what you have to deal with. I am sorry if it came across negatively.

  • RagingToad@feddit.nl
    2·
    10 months ago

    Allergic to Indices? If your database is slow just add more Indices until you have one on every column of every table! :-)

    • GBU_28@lemm.eeEnglish
      2·
      10 months ago

      Hi I need to add some data to the database.

      No you fucking don’t

  • FreshLight@sh.itjust.works
    1·
    10 months ago

    The guy after him:

    “Hmm since I don’t feel like looking in the documentation for every possible key of this attribute, I’ll just throw a distinct. And while I’m at it, let’s do this for every attribute that I don’t know the keys of”