• 0 Posts
  • 599 Comments
Joined 2 years ago
cake
Cake day: June 13th, 2023

help-circle

















  • The question as asked: you can do it anywhere. Right here. In worldnews. Lemmyshitpost. Gardening. Whatever.

    But I think you’re asking: where can I say whatever I want without consequences?

    And that’s harder. Because if you have the right to subject other people to your opinions, that gives them the right to subject you to their opinions.

    If you want to avoid being banned, create your own community. If you want to avoid your community being nuked by admins, create your own Lemmy instance. If you want a safe space for yourself, free from criticism about what you say, don’t federate your instance. You will be safe and able to howl into the wind without anyone troubling you.



  • I found code that calculated a single column in an HTML table. It was “last record created on”.

    The algorithm was basically:

    foreach account group
      foreach account in each account group
        foreach record in account.records
          if record.date > maxdate
            max = maxdate
    

    It basically loaded every database record (the basic unit of record in this DATA COLLECTION SYSTEM) to find the newest one.

    Customers couldn’t understand why the page took a minute to load.

    It was easily replaced with a SQL query to get the max and it dropped down to a few ms.

    The code was so hilariously stupid I left it commented out in the code so future developers could understand who built what they are maintaining.