• 0 Posts
  • 15 Comments
Joined 2 years ago
cake
Cake day: August 16th, 2023

help-circle






  • If your connection is stable, the latency will more or less be the same, but TCP will consume more bandwidth because of acknowledgement packets, making it harder to keep your connection stable.

    On an unstable connection, TCP latency will skyrocket as it resends packets, while UDP will just drop those packets unless the game engine has its own way of resending them. Most engines have that, but they only do it for data that is marked as “important”. For example using an item is important, but the position of your character probably isn’t, because it’ll be updated on the next tick anyway.


  • old webpages (like from the 2000s) are fast and snappy. new webpages take much longer to load.

    This part is true, especially on phones, but those old webpages were not fast at all when they were first published.

    I remember trying to watch videos on dialup Internet. I’d make it start buffering and then go do something else for half an hour before coming back to watch the video. I also remember avoiding certain websites even on DSL because they had 1 or 2 whole megabytes of JavaScript and it took forever to load.

    Increases in bandwidth and processing power has made those old websites seem a lot more performant than they were at the time.

    Today we can put a lot more stuff on our websites than we used to, which makes things slower, but we’re also much more aware of major performance issues. Google uses it as a factor in their ranking algorithm, and offers a pretty intelligent tool to help developers figure out where to optimize their websites, so it’s essential for most companies to optimize for that. Giant companies like Amazon and Facebook can ignore it because they’ll always be on top, but the rest of us are getting really excited about new frameworks like solid and qwik that will make it a lot easier to optimize our sites.





  • Postgres normalizes table and field names to lowercase, unless you put them in quotes. It’s also case sensitive.

    That means if you use quotes and capital letters when creating the table, then it’s impossible to refer to that table without using quotes.

    It also means if you rename the table later to be all lowercase, then all your existing code will break.

    Still a much better database than MySQL though.